Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 983
CodeGrue Avatar asked Mar 29 '10 21:03

CodeGrue


1 Answers

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

like image 179
CodeGrue Avatar answered Nov 16 '22 09:11

CodeGrue