sql server reporting services: need help to get total of a report field -- sql server reporting services

need help to get total of a report field

bob
1/12/2005 9:24:23 PM

sql server reporting services: Inside a group i have a text box name totalvalue whose value is
calculated from database field. Outside the group i am trying to
calculate the sum(ReportItems!totalvalue.value,"Group3"). I am getting
error saying aggregate function can use on report items when item is on
page header or footer. How can i sum a report field?

Re: need help to get total of a report field

Brian Welcker [MSFT]
1/24/2005 2:30:55 PM

You need to sum the underlying expression instead of the textbox. Textboxes
aren't scoped by group, they are scoped by page.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

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

[quoted text, click to view]