SSRS 2005. I have a nullable Report Parameter that I would like to be undefaulted on opening the deployed Report, so that the report does not run unnecessarily on opening it. However, in the designer, in the Report Parameters dialog, the radio buttons force me to enter a default value. I am aware that in Report Manager I can manually uncheck the 'Has Default' property but I wish to achieve the same effect programmatically, perhaps in a script run at deployment time. 1. Can I achieve an undefaulted parameter through the designer? 2. If not, can I set the parameter property through scripting, perhaps using rs.exe? 3. If not, where on the report server is the parameter property held, and is it user specific? Many Thanks.

Hi, In the Report Parameters dialog, there are 3 radio buttons for the parameter Default values. If you click Null radio button, the parameter will be undefaulted. Please do not hesitate to let me know if I have misunderstood. Regards, Jerry

Thanks Jerry, Your suggestion works if 'Allow null value' is unchecked in the dialog, but we want to allow nulls. As a result the report fires immediately, which we want to avoid. Unfortunately this brings us back to the original questions. Regards,D

Dont understand your issue exactly. I also try a nullable report parameter, which is from a T-SQL query. The option Allow null value is checked in the dialog, and I click Null radio button to the parameter Default values. Everything works fine. That farcing me to enter a default value desnt reproduce in test environment. Please post your example for your issue. Thanks, Jerry

The problem is that the report fires automatically. I want it to open without running so that I can enter a value for the parameter (or tick null). I can achieve this manually in Report Manager by unchecking the 'Has Default' property, but I don't want to have to do it manually. My three questions are - 1. Can I achieve an undefaulted parameter through the designer? [I guess the answer to this is No?] 2. If not, can I set the parameter property through scripting, perhaps using rs.exe? 3. If not, where on the report server is the parameter property held, and is it user specific? Many Thanks.D

Is there any possibility that anyone can help with this question please? Many thanks. D

Hi, As per my understanding , you need a parameter which allows a user to type a value(free text) and also needs an check box(NULL) ,the report should not run automatically and also that when user doesn't want to enter any value he can simply click on null check box and execute the report. If this is true, this is possible by creating a dummy data set, for example create a dummay dataset and the data set query will look something like: Select '' as a Now go to the parameter tab, and ensure you have unchecked "Allow Blank Value" and CHECK in "Allow Null Value". Now in the default values of the parameter select "Get Values from query" and select the dummy dataset which you have created and in value drop down select "a". And now run the report which will not run the automatically, but will wait for the user to either enter a value in the textbox or check Null value to execute the report. Summary is assiging a blank value as default value from a database to a parameter where the parameterdoes not allow blank values.Regards, Raju

Were you able solve your problem with the above example posted?Regards,Raju

Don't know if you are still following thread. If you are do you have a way that the little checkbox labeled "null" could be labeled "choose all" ?Edward R. Joell MCSD MCDBA

For any moderators Jagapatha's solution worked for me though I eventually used another method as I did not think my users would understand that a box maked "null" meant "all". So I think his solution should be marked as the answer and he should be given the points particularly since the OQ has not checked back to verify the answer.Edward R. Joell MCSD MCDBA