Multi value ssrs parameter

SSAS and SSRS
1

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.

2

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