Filters whith diferent values (parameters)

[luisfer]

I want to make a filtering by using a string parameter (a,b).
The initial result of my query is this:

Name Letter
Luis a
Juan b
Michel c

Note: There are 2 columns (Name) and (letter)

So after filtering the result pane should be like this

Name Letter
Luis a
Juan b

If i send a diferent filtering parameter (b), the result should change like this

Name Letter
Juan b

How can I do this??

Thyanks

[guytz72]

Hi,

I dont think it is possible to use multiple values for a parameter in SSRS.

I have worked around this before by creating an ASP.Net app with two list boxes (one for available, the other for selected parameters) that poplulates a table with the parameters you require. All you have to do then is inner join on that table to filter out the other records, and provide a link to the report in the web app.

Hope this helps.
Guytz72

[fatherjack]

not a whole lot of help but SSRS in SQL 2005 allow multiple selects on the parameter lists. Not your best reason to upgrade but its another one for the list!

FatherJack