hi all,

looking at the previous thread i know how to get a page sum in the footer ,
but is there any method for me to insert a total sum below the footer?

as i cant place a text box in the footer and set the expression as sum of a
field in the table.(footer wont allow sum of field)

what i can do now is a total sum above the page sum.

thanks in advance.

You can place such a sum in the appropiate grouping area of the report, set
its visibility to fasle and reference the textfield in the footer area to
this invisible field. That will work.

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"Jasonymk" <Jasonymk@discussions.microsoft.com> schrieb im Newsbeitrag
news:31020492-0616-4EBB-A183-4E78C8ED1AFA@microsoft.com...
[quoted text, click to view]