sql server reporting services: Totals and groups - how to calculate grand totals inside groupings -- sql server reporting services

Totals and groups - how to calculate grand totals inside groupings

DragonVic
10/10/2006 1:43:02 PM

sql server reporting services:

have a report that has groupings that need to figure out the percentage of
the grand total.

Example:

Group1
Count Total Count% Total%
100 1000 33.33% 25.00% <--detail
200 3000 66.67% 75.00% <--detail

Group 1 Totals
----- ------ ---------- ----------
300 4000 100.00% 100.00%

How do I code in the expression for the percentages when the totals needed
for the calculation are in the footer?

in this case count/sum(count) but at the detail level

This should be simple right?

I know that in Crystal you can calculate inside a group by specifying...
count/groupname.sum(count) or the textboxvalue.
I tried the Count/ReportItems!CountTotal.value in SRS but no luck.
and if I try duing a separate query in a different dataset it takes too long
to process because of the grouping.

RE: Totals and groups - how to calculate grand totals inside groupings

DragonVic
10/11/2006 8:45:02 AM

Got an answer from Rober Bruckner at MS...

In the table detail, you can just use an aggregate with an explicit parent
scope to perform this calculation. For example if the table group has the
name "Table_Group1":

=Fields!Count.Value / Sum(Fields!Total.Value, "Table_Group1")

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.