SSRS 检查过滤组行计数
我想在没有组范围的情况下检查已过滤组的 RowCount。
我特别想知道组何时为空，以便我可以在表中不在组中的另一行上设置 Hidden 属性。
预先感谢您的帮助。
弗兰克
更新 - 找到解决方案：
我通过反复试验找到了这个问题的答案。 ，没有数据区域声明）：
=IIF(CountRows() = 0, false, true)
我将过滤器移至 Tablix，然后在表中该组之后的下一行（在本例中为“详细信息”组）中简单地使用了后面的表达式（请注意 访问 Visual Studio 2008 中的“行”隐藏属性，只有在设计器的分组部分启用“高级模式”后，您必须选择设计器底部“行组”下的行，它们列在顶部到-底部序列。这些属性位于右侧的“属性”窗格中。
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 Tablix, 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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试添加
=IIF(CountRows() = 0, false, true)来设置 true 和 false 值。Try adding
=IIF(CountRows() = 0, false, true)to set the true and false value.