Wednesday, September 11, 2019

SSRS report: Parameter left blank to select all record

There are several ways to show all records when parameter field left blank.
For Single Valued parameter:

All records are displayed without parameter.

Now Add parameter and select check box for Allow blank value

Modify the data set to accept the parameter value.

When run the report we can't see the record for blank values.
So modify the data set to accept blank value.

Now again run the report. You can see all the records for the blank value passed through parameter.

You can view the Video below for more detail:

No comments:

Post a Comment