Parameters in SSRS

views:

154

answers:

Parameters in SSRS

I am trying to develop a report in SQL Server Reporting Services using parameters.

I have no problem creating the parameters and running the reports, but I always have to select an item from each of the parameters to make it run. Can I have the option to leave one of the parameters blank and still have the report run? Right now when I hit 'view report', I always get the error that I must make a selection to continue.

+3 A:

Check off the Allow blank value checkbox for the parameter(s) you want to allow a blank value for.

Right click anywhere outside the report on the Layout tab
Select Report Parameters
Select the parameter you want to allow blank values for
Check off the Allow blank value checkbox

Repeat as needed for each parameter.

OMG Ponies 2009-10-14 17:25:37

I have tried this with no luck. I have also tried 'allow null value' and every combination of both.

Hunter 2009-10-14 17:32:21

How are you testing? If from the server, are you sure you're deploying before testing?

OMG Ponies 2009-10-14 17:36:48

I have not deployed the report. I am using the preview tab to test the report.

Hunter 2009-10-14 17:38:55

I'm testing in SSRS 2005 - the behaviour works as expected for me in the Preview tab. If a parameter has "allow blank" checked off, I don't get prompted if I left it blank and vice versa.

OMG Ponies 2009-10-14 17:51:01

Ok, so why do you think I am getting prompted? I am obviously missing something? Could it have something to do with my SQL Query?

Hunter 2009-10-14 18:05:48

IME, it has nothing to do with the query - the values don't get to it if the View Report validation doesn't let you through.

OMG Ponies 2009-10-14 18:15:37

OMG Ponies 2009-10-14 18:16:16

That could be my problem. I am trying to get a blank value from a drop down list. I have tried it with a text box and it works, but that does not solve my problem. What is the solution for a drop down list?

Hunter 2009-10-14 18:25:05

You can set a default value in the Report Parameters, Default values section (bottom righthand corner). Select the **Non-queried** radio button, and provide the value (**not** the label value). I've found "=[value]" is what works when the report is deployed, but the Preview tab has preferred to not have the "=" portion sometimes for me.

OMG Ponies 2009-10-14 18:41:09

This does not help. It will only accept a default value that is already in the Drop Down List. If it doesn't exist in the list, it will ask me to make a selection and that defeats what I am trying to accomplish. I am thinking I might have to assign a blank record to the start of my Data Set through the query and then set that to my Default value.

Hunter 2009-10-14 18:59:32

Yes, the default value has to exist in the drop down list of values.

OMG Ponies 2009-10-14 19:09:06

Thanks for your help!

Hunter 2009-10-14 19:13:05

ansaurus

tags:

views:

answers:

Parameters in SSRS

related questions