-
Filters whith diferent values (parameters)
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
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|