Postgres Pro
Downloads
Home   >   mailing lists

Re: Query regarding to MS reporting services (Grand total problem) - Mailing list pgsql-sql

From Aaron Bono
Subject Re: Query regarding to MS reporting services (Grand total problem)
Date
Msg-id bf05e51c0609070701g7400643al3abb5326b9f8b42c@mail.gmail.com
Whole thread Raw
In response to Query regarding to MS reporting services (Grand total problem)  (Dinesh Tiwari <tiwaridinesh22@yahoo.com>)
List pgsql-sql
Tree view
On 9/6/06, Dinesh Tiwari <tiwaridinesh22@yahoo.com> wrote:
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.

 
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
==================================================================

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Is it possible to left join based on previous joins result
Next
From: Emi Lu
Date:
Subject: Re: Is it possible to left join based on previous joins result