Parameters

Question

Parameters

edward_hall76

SSC Eights!

Points: 882
More actions
October 3, 2014 at 7:04 am

#311518

I am working on an ssrs report and they want to be able to search by 3 parameters City, zip code and state and have it where you can pick 1 parameter, 2 parameters or all 3 what is the easiest way to do that. would it be 3 data setes or how can i do that from one data set.

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

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

Alan Burstein SSC Guru Points: 61136 More actions · Answer 1

edward_hall76 (10/3/2014)
I am working on an ssrs report and they want to be able to search by 3 parameters City, zip code and state and have it where you can pick 1 parameter, 2 parameters or all 3 what is the easiest way to do that. would it be 3 data setes or how can i do that from one data set.

The best way to approach this would be to have a dataset for each parameter. Then make the parameters NULLable so that the default "Please select..." message does not appear.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

edward_hall76 SSC Eights! Points: 882 More actions · Answer 2

I have it where it pulls parameter by state and now I want to have a parameter ZipCode. Do I need to do a shared dataset because if I just add dataset nothing comes up if I enter zip code or state and I have them null in parameters.

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 3

You need a dataset for each parameter. a piece of code that populates the parameter list. You could also use cascade parameters - meaning, if you choose a state, then the city parameter only lists cities in that state. Here are some articles:

http://technet.microsoft.com/en-us/library/aa337432(v=SQL.105).aspx

http://technet.microsoft.com/en-us/library/ms159266(v=SQL.100).aspx

http://technet.microsoft.com/en-US/library/aa337498(v=SQL.105).aspx

http://technet.microsoft.com/en-us/library/aa337169(v=SQL.100).aspx