SSRS Check Filtered Group RowCount

Question

I would like to check the RowCount of the filtered group without group capability.

I would especially like to know when the group is empty, so I can set the Hidden property to another row in a table that is not part of the group.

Thanks in advance for your help.

Franc

UPDATE - SOLUTION FOUND:

I found the answer to this question through trial and error. I moved the filter to Tablix, and then I just used the following expression (note that in the next row of the table after the group there was no data region declaration), which was the Details group in this case:

 =IIF(CountRows() = 0, false, true) 

Please note that to access the hidden "Row" property in Visual Studio 2008, only after enabling the "advanced mode" in the grouping section of the designer, you must select the line in the "Group of lines" section at the bottom of the designer, they are listed in the sequence above down. Properties are in the Properties panel on the right.

Answer 1

Try adding =IIF(CountRows() = 0, false, true) to set the value to true and false.