SQL Reporting Services 2005 Passing NULL value when using Query drop down for parameter.
Posted on 2006-07-18
In the Report Parameters dialog, I have a Parameter which allows NULL values therefore I have ticked the Allow null value. The parameter uses a query to get the list of valid responses when a user inserts this information. However when viewing the report there is no way of passing a NULL value, if I change the parameter to a text box a null value checkbox is present.
Is there any way of using a query for a parameter and being able to pass a null value, without having to insert a row (for the query to pick up) and then testing whether the user has selected this row and use it as a null value?