SSRS Show Row Based on Custom Parameter

KANEDA 0149
KANEDA 0149 used Ask the Experts™
on
I have a DataSet1 where the field is called "RowOrder" which contains 1 thru 4 (as shown below).  I want to a create a new parameter where if they select All = NULL (i.e. show all), Total Portfolio = 1, Asset Class = 2, Mutual Fund = 3 and Security = 4 which corresponds to the RowOrder field in DataSet1.

Attached is a screenshot of my parameter called Level where I have defined the Label and the corresponding Values to match RowOder.  How do I get the row to show or hide based on the @Level parameter selected?  Thanks

Level Parameter
Sample Output Showing RowOrder Value
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial