CODEWITHSUNDEEP
ssrs-2008-r2ssrs-2012
Shivang
Shivang

Reputation: 251

Displaying data based on condition in SSRS

I am developing a report in SSRS and need help with displaying the data based on a few conditions.

2 CONDITIONS: (Please refer the image below)

1) 3 days in the Current Full Week with % above the 2% bench mark

It means that if a Restaurant R2 and R5 are not having has minimum of 3 values > 2% so it should be eliminated

OR

2) 5 days in the Current Full Week & Prior Week (i.e. across the last 2 weeks) with % above the 2% bench mark

Here again R2 and R5 should be eliminated from report as Current Week and Prior Week values are not having minimum of 5 values >2%

Report:

enter image description here

The report structure is:

enter image description here

Final Output:

enter image description here

So in short the report should only display restaurants meeting the above 2 conditions.

Upvotes: 0

Views: 918

Answers (1)

William Xu
William Xu

Reputation: 261

You can use Row Visibility to control it. (As shown in your screenshot above) Left click the gray box on the left to the [StateName], select "Rowe Visibility", then "Show or hide based on an expression", and apply your condition there.

Upvotes: 1

Related Questions