SQL Server Performance Forum – Threads Archive

Help with totals!!!

I have a simple select query displayed in Table control. What I want to do is to display a total at the end of each page ( In the table footer or page footer ). Its actually a sum of a particular column. How do I do this.

---

Hi, To add totals just add the field in your page footer, the report designer will automatically assign the necessary formula Try it and let my know if you require more infos Akthar

---

Hello Akthar, I have tried what you suggested but I get this reporting error. "The Value expression for the textboxname refers to a field. Fields cannot be used in page headers or footers.
Any further suggestion would greatly be appreciated. Thank You!

---

Hello,
From the field list, just drag drop the relative field to table footer or report footer section. On doing so, you might see the formula as "=Sum(Fields!Col1.Value)". This will give you the total of the column that you have displayed in the detail section of the table. Thanks, Bijesh

---

Hi Bijesh, Thanks for your reply,My exact requirement is to get page level totals on each page of the report. If I drag drop the relative field to table footer, the result is total of that column for the complete report. If I drag drop the relative field to report footer that’s when I get the above posted error. If you have any suggestion please let me know how to display column total for each page? Thanks for your help in advance! Thank you!

---

Hi Fountainhead, Check this MSDN site: http://msdn.microsoft.com/library/en-us/rscreate/htm/rcr_creating_expressions_v1_1l6b.asp?frame=true Thanks, Bijesh

---

]]>