Thread: Query regarding to MS reporting services (Grand total problem)
Hi,
I have a problem reagarding Grand Total in the table footer.
I am showing only top 10 seeling for each department in report but i want sum of whole table seelings in table footer. not only 10 sellings which are shown in report. I want the sum of all 40 thousand rows.
How i can do it.
If any one have idea about this please help me.
Thanks in advance.
Regards
Dinesh Tiwari
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
On Tue, Sep 05, 2006 at 10:30:19PM -0700, Dinesh Tiwari wrote: > If any one have idea about this please help me. My idea is that you ask on a list that supports MS SQL Server. This isn't one. A -- Andrew Sullivan | ajs@crankycanuck.ca If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA
On 9/6/06, Dinesh Tiwari <tiwaridinesh22@yahoo.com> wrote:
In general I would recommend you run two separate queries - one for the report and another for the footer - and then union the two.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
Hi,I have a problem reagarding Grand Total in the table footer.I am showing only top 10 seeling for each department in report but i want sum of whole table seelings in table footer. not only 10 sellings which are shown in report. I want the sum of all 40 thousand rows.How i can do it.If any one have idea about this please help me.Thanks in advance.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================