datereporting-servicesparametersdefault

SSRS date default with formula disables parameter

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. Does anyone know what simple thing (I am sure) I am doing wrong?

Solution

  • 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