The Problem
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:
=Today()
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 solution
The problem can be resolved by changing the order of the parameters.
By changing the order from:
- Person ID
- End Date
to
- End Date
- Person ID
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.