Geek asks and answers

SSRS 2008 Filter not in "not in"?

I want to configure a filter in SSRS 2008, and I need the user to select values ​​from EXCLUDE from the report. Therefore, I expected that I would have a filter configured as "not in" the parameters, but I do not see this. Am I missing something? Can you come up with a workaround?

For example, if I have sales by state, and I know that there are 3-4 states that my user might want to exclude from the report. I don’t want him to have to go through a list of 50 states in order to remove marks from these 3 or 4, but only to present these 3-4 in the list to ask him if he wants to exclude them or not.

thank

+3
source share
2 answers

3-4 . .

SELECT 'Arizona'
UNION 
SELECT 'California'
UNION 
SELECT 'Great Washington Area'
UNION
SELECT 'Nevada'.

, , , , " " .

0

More articles:


All Articles