开发者

SSRS Check Filtered Group RowCount

I would like to check the RowCount of a filtered group from without the scope of the group.

I particularly would like to know when the group is empty so that I can set the Hidden property on another row in the table that is not in the group.

Thanks in advance for your help.

Frank

UPDATE - SOLUTION FOUND:

I found the answer to this question through trial and error. I moved the filter to the Ta开发者_开发百科blix, and then I simply used the expression that follows (Note that there is no data region declaration) on the next row in the table after the group, which was in this instance the Details group:

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

Note that to access a "Row" hidden property in Visual Studio 2008, only after enabling "Advanced Mode" on the grouping section of the designer you must select the row under "Row Groups" on the bottom of the designer, they are listed in top-to-bottom sequence. The properties are in the "Properties" pane to the right.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜