May 24th, 2012, 01:55 AM
Join Date: May 2012
Time spent in forums: 29 m 48 sec
Reputation Power: 0
SSRS Multi-Value with Option = ''
I have created a report in SSRS.
In it, I have a multi-value parameter, namely Semester.
In this Semester parameter, Available values are taken from database, Default values are:
SELECT DISTINCT [STUDYSEMESTERS] FROM [STUDENT]
SELECT '' AS STUDYSEMESTERS
In STUDENT table, I have several records with STUDYSEMESTERS = '' (blank).
I have set Semester parameter to allow blank.
Now, I want the report to show me records with Semester value = ''.
The report is run and show me error: Please select a value for the parameter [Semester].
In the Semester parameter, I have only one option selected, that is ''.
Can someone help me on how to work around this so that I can run the report with no problem even when I only select option ''?