Daniel Trocker
asked on
How is it possible to choose multiple values in a filter in SSRS?
Hi,
when setting a parameter I chose "allow multiple values". I took this parameter as the basis for the filter in the report, but did not manage to choose multiple values in the report. Whenever I choose more than 1 value (or "select all"), the report shows only the 1st value of the filter.
In my case (see attachment) the report is showing only the value "500".
Thank's for your help
Daniel
when setting a parameter I chose "allow multiple values". I took this parameter as the basis for the filter in the report, but did not manage to choose multiple values in the report. Whenever I choose more than 1 value (or "select all"), the report shows only the 1st value of the filter.
In my case (see attachment) the report is showing only the value "500".
Thank's for your help
Daniel
Continuing from @Vitor's comment, here's how it looks in your query with the parameter:
SELECT *
FROM YourTable
WHERE [YourField] IN(@ParameterName);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, I found out myself now. Under "Tablix propoerties" --> "filters" --> "Value" i had "=Parameters!Region.Value( 0)". Now i changed to "=Parameters!Region.Value" and it works.
Report Comment
Report Comment
Author solved their own problem and posted the solution.
The first only returns a single record and the latter returns all records in the list. Ex: FieldName IN (100, 200, 300, 400, 500)