December 19, 2016 at 2:07 pm
In an ssrs 2008 report, I have a user that would like to select 2 different parameters sometimes.
Some times the user would like to:
1. select only zip code,
2. select only city and state, or
3. select both zip code and city-state combination.
In SSRS 2008 reports, I do not see how this is possible? If I am incorrect would you let
me know how to accomplish this goal?
If this is not possible, the only option I can see is to create another parameter where the
options would be to select:
1. select only zip code,
2. select only city and state, or
3. select both zip code and city-statement combination.
Once this option is selected, then the appropriate option would be to:
have the requested parameters be available to request.
Let me know what you suggest would be the best option.
December 20, 2016 at 1:59 pm
It sounds like cascading parameters might be what you're looking for:
https://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/dd255197(v=sql.105).aspx
December 21, 2016 at 8:15 am
why would I want cascading parameters? some parameters would not be picked
December 21, 2016 at 11:21 am
That's the point. The cascading activates some parameters and not others. They are used for what you described here:
create another parameter where the
options would be to select:
1. select only zip code,
2. select only city and state, or
3. select both zip code and city-statement combination.
Once this option is selected, then the appropriate option would be to:
have the requested parameters be available to request.
Of course, the simplest thing is just have the three parameters (zip, city, state) and let the users select whichever combination they want. In this scenario, to avoid what Gail Shaw calls Catch-all query issues[/url], you might want to make your query dynamic.
But cascading parameters are the only way I know to make parameter activation dependent on other parameters (so if City is used, State must also be used).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply