SSRS 2008 Assign default value for parameter
Posted on 2011-02-17
I have an SSRS report tied to a SQL stored procedure. The stored procedure takes a nullable parameter. So I created an SSRS report parameter to pass to the stored prccedure. On the Report Parameter Properties General tab, I have the Allow Null Value checkbox checked. On the Available Values tab I've selected Get Values from Query, specified the dataset, value and label fields. And on the Default Values tab I've selected Specify Values and the value (Null) appears in the listbox below. When I preview the report, the dropdown box for the parameter reads <Select Value> and if you click on the down arrow all the expected values are there. If I select a value, it works fine. If I do NOT select a value, I get a message telling me to select a value. I thought I set it up to Allow NULL values and specified that NULL was the default value. What am I doing wrong? I want NULL to be passed in if nothing is selected.