Hide the row in ssrs based on group

1
votes

Current Situation

Expectation

Problem facing

Hi , I am developing a ssrs report. And I have using two level of groups outer and inner group .

=IIF(RowNumber("GroupbyCategory") > 1, True, False)

I am trying with above code in row visibility, its working fine for single row. If the group contains more than one row, then its hide the first row. is there any possible to achieve as per expectation image. Thanks

1
reporting-servicesssrs-2012
Why do you want to hide the first row in first outer group? What is the logic/condition? – Anup Agrawal
Thanks for your comment, this is for requirement with low priority. Is it possible? no need to show the details row if that group contains only one row. So that only. – Singaravelan

1 Answers

1
votes

To achieve as per the expected image. You need to add the condition that hide the first row only if the row count of the inner group is 1.

=IIF(RowNumber("GroupbyCategory") = 1 AND CountRows("GroupbyCategory") = 1, False, True)