Select ALL values by Default–SSRS

Requirement:

Client requested to select all Options which are available in “Lead Source” report Parameter.

Steps to Implement:

1. Create a Data set “LeadSource_Dataset” to get all Lead Sources from the system (I have retrieved all distinct values from Opportunity entity because I need a report on Opportunity Entity).

2. Create a Parameter as “LeadSource” and Enable for “Allow Multiple Values”

3. Select “Available Values” from LeadSource_Dataset

4. Select “Default Values” from LeadSource_Dataset

I ran the Report, but “Lead Source” not selected with all options by default.

Reason for the issue:

Default values will not be set for Report Parameter if Dataset has any NULL values. My query is to get Distinct values from Opportunity Entity. By this, I got NULL value also so Parameter didn’t set Default values.

I have included “LeadSource not null” condition in “LeadSource_Dateset” and Re-ran the report. Now, Report Parameter selected with all Available options and executed the report.

Hope this helps someone