I have an SSRS Report with a default date parameter.
The default date parameter appears grayed out and does not allow me to enter the date
The problem in detail
In an SSRS report I wanted to have a Default date parameter.
The report had two parameters:
Person Id – Free Text Number field, Mandatory
End Date – Date Field – default to Now
The default value for the date parameter can be set by a default expression like:
When this report is opened the cursor is focused in the “Person ID” field, and the End Date is grayed out.
Enter a PersonId and either tab out of the field or click view report and the End date field will become available.
The problem can be resolved by changing the order of the parameters.
By changing the order from:
It appears that placing a text style parameter that requires user input prior to the default date field, stops the parameter execution and leaves the field grayed out.