Is this possible for parameter

Question

 

Hi all,

 

Is the following possible:

 

I have three parameters and the users wish to only use one of them and run the report. They might use A or B or C parameters. But you cannot leave parameters blank in RS, therefore if parameters are set-up they need to have values. I guess I can put default values and then in my SQL do some kind of case. But was wondering if you can leave some parameters blank in RS?

 

Thanks

Answer 1

If a default value is not provided in the report then upon delivery the user will be prompted for the parameters value.  If you provide default values then the report will be rendered with the default value, but the user will have the ability to change the value(s).

 

Hope this helps

Answer 2

 

So there is no way of leaving the paramters (or some of them) blank?

 

Answer 3

They can be left blank, but the report will not be rendered unless the user provides all parameters or default values are provided in the rdl.

 

Answer 4

ok so in order to run a report u need to have parameters blank and they need to be filled.

 

Thanks for your help.

 

Answer 5

 

Ive jus found out u can leave parameters blank by setting up Allow blank values in reporting parameters....