SQLTeam.com | Weblogs | Forums

Ssrs 2008 selecting parameters


#1

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.


#2

see https://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx