all groups > sql server reporting services > april 2005 >
You're in the

sql server reporting services

group:

Report Footer Not Showing Grand Totals


Report Footer Not Showing Grand Totals Mike Harbinger
4/21/2005 1:36:45 PM
sql server reporting services:
Using the report wizard I built a report to break the page on a given
customer name. The wizard built a single detail row and a header. I then
added a group footer to break on customer name so I would see a total for
each customer. This all worked fine. I then wanted to see a grand total so
enabled the table footer. However the result is the table footer is acting
like the group footer and shows the same totals, not the report grand total.
I use the table footer in my other reports for a report grand total and it
works fine. What am I missing?

Thanks!

Re: Report Footer Not Showing Grand Totals Lev Semenets [MSFT]
4/21/2005 9:46:24 PM
In this case Report Wizard creates list to do page breaks and puts table in
the list. That is why table sees only part of data.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: Report Footer Not Showing Grand Totals Mike Harbinger
4/23/2005 2:44:50 PM
How can I get a grand report total using when breaking on the page?

[quoted text, click to view]

Re: Report Footer Not Showing Grand Totals Lev Semenets [MSFT]
4/25/2005 11:35:12 PM
Create textbox at the bottom of report and set its value to
=Sum(Fields!blabla.Value)
This may work of you have plain report without filtering or hiding.


--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

AddThis Social Bookmark Button