Allowing Report Viewing if No values in the Dropdown Parameter is selected

Question

Allowing Report Viewing if No values in the Dropdown Parameter is selected

Stylez

SSCrazy

Points: 2195
More actions
February 25, 2008 at 8:44 pm

#186930

Hi All,
I would like to ask if it is possible for me to view my report in runtime without selecting a value on one of my dropdown parameters(E.G. Gender (Male/Female)) i always get an error everytime i hit the View Report button if i dont select a value from my dropdown. any help would be gladly appreciated
Thanks
N.O.E.L.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

You have to allow Null or empty for the report parameter. Then you need to make sure your data source handles the null or empty string value. I usually add an "ALL" value to my dropdowns where I do not want to force a choice. If you are getting the data from a query I usually do:

Select id, value from table union select Null (or 0) , 'ALL'

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Stylez SSCrazy Points: 2195 More actions · Answer 2

Hi Sir,

I Modified The Reporting Parameter to Allow null, but the RS doesnt allow me to do so. i've already set a Dummy Value('ALL') to the Select Statement which will display the available values in my dropdown parameters but still the report manager prompts me to forcely select a value from the dropdown.

Best Regards,

N.O.E.L.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

but the RS doesnt allow me to do so

I'm not sure what you mean by this. Do you mean that you can't set the parameter to allow Null? What does your data source do if it gets passed a null or 'ALL' value?

Unless you supply a default for a drop-down parameter you will have to select a value, which is why I supply the 'ALL'. If you set the default to the 'ALL' value the report will run using that.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Stylez SSCrazy Points: 2195 More actions · Answer 4

Hi Jack.

I've Done It.I've tested it in my reports and it did the thing for me.

thank you very much for your assistance.

Best Regards,

N.O.E.L.