Reporting Services 2005 中的组和小计列 [英] Group and subtotal columns in Reporting Services 2005

问题描述

我有一份我继承的报告(RS2005，针对 MSSS2005 实例).它显示了一个基本的数据表:一些用于将行组合在一起的关键字段，一些基本的数字字段，然后是一些过时(桶")字段(例如 1 个月、2 个月、6 个月、一年、两年等)

I have a report (RS2005, against a MSSS2005 instance) which I have inherited. It shows a basic table of data: a handful of key fields which are used to group rows together, a few basic numeric fields, then a number of dated ('bucketed') fields (e.g. 1 month away, 2 months, 6 months, a year, 2 years, etc.)

用户希望在聚合组中将这些注明日期的字段组合在一起，并且能够像折叠行一样折叠或展开列.因此，我们将能够显示下一年的值的小计或扩展它以按月细分.如果显示小计，则隐藏各个月份.

The user would like to group together these dated fields in aggregated groups and be able to collapse or expand the columns as you can the rows. So we'd be able to show the next year's values' subtotal or expand it to break it out by month. Hiding the invidual months if the subtotal is shown.

这是基本的数据透视表行为(并且可以使用 Excel 上的组/小计功能来完成 - 这是我可以用来描述需求的最接近的类似行为).

This is basic pivot table behaviour (and can be done with the Group/Subtotal feature on Excel - that's the closest analogous behaviour I could use to describe the requirements).

虽然在 RptgSvcs 中按行分组似乎微不足道，但将列分组并将一个组折叠成一个小计并再次将其删除似乎很难甚至不可能.

While grouping by rows seems trivial in RptgSvcs, grouping columns and collapsing a group into a single subtotal and blowing it out again, seems hard to impossible.

除非有人知道得更好?

推荐答案

您应该能够通过选择要隐藏的列并将其可见性设置为隐藏来实现此目的.

You should be able to do this by selecting the columns that you would like to hide and set their visibliity to be hidden.

然后将隐藏列上的切换项设置为显示小计的文本框.

Then set the toggle item on the hidden columns to be the textbox that shows the subtotal.

此文本框上将带有 [+] 符号，单击将显示/隐藏您的逐月突破(隐藏列).

This textbox will then have the [+] symbol on it, and clicking will show/hide the your month-by-month breakout(the hidden columns).

这篇关于Reporting Services 2005 中的组和小计列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！