"Show Group Subtotals" Reappear when opening a report

This should be pretty simple...

I have a report that I've designed in Report Builder with many groups. I added an aggregate. By default, it subtotals at each level. For all the groups (but 1) I right clicked on the group header and unchecked "Show Group Subtotals".

I save the report to the report server in "My Reports". When I open the report, all of the subtotals return.

Does anyone know why this occurs? I'm going to have a hard time selling this to business users if they have to go through each group and uncheck the "Show Group Subtotals" every time they want to modify a report.

Regards,

Dan

This is a known issue that is fixed in internal builds. The release in which this fix will be available has not been determined yet. If it is a showstopper for you, you might consider calling customer support and requesting a hotfix.

|||

Thanks for the quick response! I'll wait to see how users react before pursuing it further.

Thanks again,

Dan

"Other" grouping or Row aggregate

AS 2005, SP1:

I have a dimension with 15 members which I can filter the Top N members by measure.
What I would like to do is append an additional Row as a group or aggreagate the reads "Other" that reflects the remaining measure value. For example,

Top 5 Widgets

W5 5000
W9 4000
W2 3000
W11 2000
W7 1000
+Other 6000

The "Other" Row would sum the remaining 10 widgets so the user could see 100% of the totals.
I can do the Top N but have no idea how to start this one. Thanks in advance for your help.

-Troy

Reed Jacobson wrote up the standard solution to this problem on his blog recently:
http://sqljunkies.com/WebLog/hitachiconsulting/archive/2006/08/03/22345.aspx

In AS2K this could be optimised, and I wrote up how on my blog here:
http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!170.entry
... however, you'd need to test whether this was still a good idea in AS2005 - I think it might actually harm performance.

HTH,

Chris

|||Sorry for the delay. This was exactly what I what was looking for.

Thanks Reed.