SSRS – Default Date Parameter not showing

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:

  1. Person Id – Free Text Number field, Mandatory
  2. 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:

  1. Person ID
  2. End Date

to

  1. End Date
  2. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.