Link to home
Start Free TrialLog in
Avatar of KANEDA 0149
KANEDA 0149Flag for United States of America

asked on

SSRS Show Row Based on Custom Parameter

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

User generated image
User generated image
ASKER CERTIFIED SOLUTION
Avatar of xav056
xav056

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KANEDA 0149

ASKER

Thank you xav056, that worked!