SSRS date default with formula disables parameter

Question

When I set a default value formula for a date parameter in SSRS, such as:

=CDate(”01/” & Month(Now) & “/” & Year(Now))

or even:

=Now

The date parameter control becomes disabled with nothing in it. Anyone know what simple thing (I am sure) I am doing wrong?

Answer 1

Now is a function and you must use like =Now()

maybe it is your problem.

Answer 2

After playing some more, I realized that the date controls became enabled when I picked a value from a preceding dropdown parameter that did not have a default. Apparently, controls after non-default parameters are disabled until you pick something, so order matters.

From an MDSN article:

"parameter order is important when you want to show users the default value for one parameter before they choose values for other parameters"

http://msdn.microsoft.com/en-us/library/cc281392.aspx