Tuesday 19 August 2014

SSRS - Conditionally Hide Tablix / Matrix Row Total


1.    Select Entire Tablix Row to hide that contains Total.

2.    Right Click > Row Visiblity.

3.    Select Show and Hide based on condition.

4.    Write Expression.

5.    =IIF(CountDistinct(<Field_Name>)>1,False,True)


6.    Add Field_Name from table.

Note: On the <Field_Name> if the Count is greater then 1 then it will show total else it will hide the row.

No comments:

Post a Comment