From tiwaridinesh22@yahoo.com Wed Sep 6 05:30:24 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 16DBF9FA1A7 for ; Wed, 6 Sep 2006 02:30:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96851-10 for ; Wed, 6 Sep 2006 02:30:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web36402.mail.mud.yahoo.com (web36402.mail.mud.yahoo.com [209.191.91.194]) by postgresql.org (Postfix) with SMTP id 214199FA418 for ; Wed, 6 Sep 2006 02:30:19 -0300 (ADT) Received: (qmail 15341 invoked by uid 60001); 6 Sep 2006 05:30:19 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=YcasC/nePY18GEu2tTVVKP+3o/VtaHKtrQNCPxHuiUlRJFKccQJf2ubcdWHB5WGgEA/PiGcV8P6csnRjTfcSzVNxO1i4P4m6JVYy6jaHgjq5NFsVfavwfJT4QNpOdTiM1rXZ5BCJuj0WRxMQf85WdsWm+Rj5yihf/9jTfsKWtrw= ; Message-ID: <20060906053019.15339.qmail@web36402.mail.mud.yahoo.com> Received: from [61.11.56.17] by web36402.mail.mud.yahoo.com via HTTP; Tue, 05 Sep 2006 22:30:19 PDT Date: Tue, 5 Sep 2006 22:30:19 -0700 (PDT) From: Dinesh Tiwari Subject: Query regarding to MS reporting services (Grand total problem) To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-539041637-1157520619=:8383" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.153 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_30_40, HTML_MESSAGE X-Spam-Level: ** X-Archive-Number: 200609/32 X-Sequence-Number: 26243 --0-539041637-1157520619=:8383 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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! Messenger’s low PC-to-Phone call rates. --0-539041637-1157520619=:8383 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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! Messenger’s low PC-to-Phone call rates. --0-539041637-1157520619=:8383-- From ajs@crankycanuck.ca Wed Sep 6 11:31:29 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C82C79FB26F for ; Wed, 6 Sep 2006 08:31:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 25330-09 for ; Wed, 6 Sep 2006 08:31:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 83FA99FB265 for ; Wed, 6 Sep 2006 08:31:20 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GKvrW-0008Gu-MF for pgsql-sql@postgresql.org; Wed, 06 Sep 2006 07:46:34 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 76A234051; Wed, 6 Sep 2006 07:31:13 -0400 (EDT) Date: Wed, 6 Sep 2006 07:31:13 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Query regarding to MS reporting services (Grand total problem) Message-ID: <20060906113113.GA31856@phlogiston.dyndns.org> References: <20060906053019.15339.qmail@web36402.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060906053019.15339.qmail@web36402.mail.mud.yahoo.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.202 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/34 X-Sequence-Number: 26245 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 From postgresql@aranya.com Thu Sep 7 14:02:29 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E7F919FB262 for ; Thu, 7 Sep 2006 11:02:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 92190-05-3 for ; Thu, 7 Sep 2006 14:02:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id E5DAE9FB2BD for ; Thu, 7 Sep 2006 11:01:44 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so330955pyd for ; Thu, 07 Sep 2006 07:01:42 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=iS/578JXZ5fdCkxijPyUDKa3DUiEv+YyiYBfnE60n4EBVciIOgwWNNTxRrOSx6yAIfiWWJzZEPrEtKao9bM4bNkoaWmpC8t/YV4QUt1bttxGF7JZHgk5sL0TUXxx4GN4+biK0t5RDAhVaF14Wq5kLqd3gYOPVe0a4VXWslaGZ6Q= Received: by 10.35.22.17 with SMTP id z17mr740800pyi; Thu, 07 Sep 2006 07:01:42 -0700 (PDT) Received: by 10.35.80.9 with HTTP; Thu, 7 Sep 2006 07:01:41 -0700 (PDT) Message-ID: Date: Thu, 7 Sep 2006 09:01:41 -0500 From: "Aaron Bono" To: "Dinesh Tiwari" Subject: Re: Query regarding to MS reporting services (Grand total problem) Cc: pgsql-sql@postgresql.org In-Reply-To: <20060906053019.15339.qmail@web36402.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23863_15965045.1157637701676" References: <20060906053019.15339.qmail@web36402.mail.mud.yahoo.com> X-Google-Sender-Auth: d1658943f4e6ec8c X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.696 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/48 X-Sequence-Number: 26259 ------=_Part_23863_15965045.1157637701676 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 9/6/06, Dinesh Tiwari 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 ================================================================== ------=_Part_23863_15965045.1157637701676 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
================================================================== ------=_Part_23863_15965045.1157637701676--