Hello :)
I have a parameter that provides a dropdown list in the report, and I would like to make it optional, that is, I want a report to run even if I don't select anything from the list, and to have a Null checkbox next to it, that regulates if the parameter is optional or not. The parameter is declared in stored procedure and is = null, and in the query is WHERE (p.somename = @parameter or @parameter is Null), also in the parameter properties in the ssrs I checked "allow blank value" and "allow null value", for the available values it's set to "get values from the query" (second dataset) and default values are set to "no default values" (in ssrs 2008 there is no option for null for the default values like in ssrs 2005).
When I run the report I have to select the values from the dropdown list which I want it optional, to run the report whether or not anything is selected. Can anyone help?