SQLTeam.com | Weblogs | Forums

Multi value ssrs parameter

trying to figure out how to create a parameter that will return either a) qty greater than 0 or b) all results.

even a checkbox that would let the user toggle between all results or only results that are greater than 0

for eample if you wanted to see only parts with qty on hand or all parts regardless of qty on hand

hope that makes sense.

Thank you.

In your query you can change the where clause to something like this:

WHERE (CASE WHEN @MyParamName = 'ALL' THEN 1 ELSE QTY > 0 END)>0