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
Avatar of xav056

Link to home
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


Thank you xav056, that worked!