有条件地删除 Reporting Services 中的分组 [英] Conditionally removing a grouping in reporting services

问题描述

我有一份报告，按位置分组显示.例如，我有按地理区域分组的商店.

I have a report that is displayed with a grouping per location. For example, I have stores grouped by geographic regions.

我想有条件地删除该组，以便不按地区分组，而是简单地按字母顺序列出所有商店.

I would like conditionally to remove the group so that, instead of being grouped by regions, all the stores are simply listed alphabetically.

这可能吗?区域在一个组中，商店在一个详细信息组中.

Is this possible? The regions are in a group and the stores are in a detail group.

推荐答案

在带有分组的控件中，您只需将分组设置为以某物为条件，通常为参数.并更改分组页眉/页脚的可见性.

In the control with the grouping, you simply make the grouping conditional on something, usually on a parameter. And also change visibility of the grouping header/footer.

在控件的分组和排序"对话框中，您将进行分组

In the "Grouping and Sorting" dialog for the control you'd have the grouping something like

 = iif(Parameters!GrpByRegion.Value, Fields!StoreRegion.Value, "")

在分组标题的隐藏"属性中(例如在表格中)

In the "Hidden" property for the grouping header (say in a table) you'd have

 = iif(Parameters!GrpByRegion.Value, false, true)

这篇关于有条件地删除 Reporting Services 中的分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！