sql server reporting services: Grand Totals in Report Footer? -- sql server reporting services

You're in the

sql server reporting services

group:

Grand Totals in Report Footer?

burt_5920 NO[at]SPAM yahoo.com
7/27/2004 4:54:46 PM

sql server reporting services:

I have a table report with five groups and want to add grand totals to
my report footer. But if I add a field to the footer:

=Fields!Period_MonthToDate_Measures_B.Value

The footer shows the total of only the first item in the highest level
group. If I use a sum function:

=Sum(Fields!Period_MonthToDate_Measures_B.Value)

The total is five times the actual total, I guess due to the fact that
I have five levels.

How do I show the correct report total?

Thanks,

Re: Grand Totals in Report Footer?

Kevin B
8/13/2004 10:43:23 PM

Burt - I have been looking for an answer to a similar question - It would
strongly appear that MS didn't include this type of feature in this
release....and that is a kind way of putting it.

-KB

[quoted text, click to view]

Re: Grand Totals in Report Footer?

mireille.azar NO[at]SPAM ifsal.com
8/25/2004 3:06:01 AM

i had the same problem and i solved it with the runningvalue

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.

home · blog · groups

Questions? Comments? Contact the dn