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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <tiwaridinesh22@yahoo.com>
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

<div>Hi,</div>  <div>I have a problem reagarding Grand Total in the table footer.</div>  <div>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.</div>  <div>&nbsp; How i can do it.</div>  <div>If any one have idea about this please help me.</div>  <div>Thanks in advance.</div>  <div>&nbsp;</div>  <div>Regards</div>  <div>Dinesh Tiwari</div><p>&#32;
		<hr size=1>How low will we go? Check out Yahoo! Messenger’s low <a href="http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com"> PC-to-Phone call rates.
--0-539041637-1157520619=:8383--