CODEWITHSUNDEEP
sql-serverreporting-services
Roko
Roko

Reputation: 13

Conditional report parameters in Reporting Services

I have a report which requests a parameter value for customerNo. The report should return all values by default.

Once the user provides a single customerNo value, then it should display the specified record only.

I've found solutions for Multiple selection, but couldn't find for single text box entry. Thanks guys..

Upvotes: 1

Views: 747

Answers (1)

Bryan
Bryan

Reputation: 17703

Report Design

Change the report parameter to allow NULL:

SSRS Parameter Allow NULL

Modify the WHERE clause of the data set to check NULL parameter value:

SSRS Dataset

Report Execution

When the report is run, users can check NULL for all rows:

SSRS Report All Rows

Or rows matching a specific value:

SSRS Report Parameter Value

Upvotes: 1

Related Questions