Print Page | Close Window

SQL

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=631
Printed Date: 28 Apr 2024 at 1:49pm


Topic: SQL
Posted By: shamee_banu
Subject: SQL
Date Posted: 07 May 2007 at 8:48pm
 
                           Part ID
Date                   50019     50013     50012     50010     Total
 
11/5/2006            3             5              14          1         23                             
 
12/27/2006          7             4               6           5         22
 
2/13/2007            9             7              7           12        35
 
3/7/2007              2            5              15           7          29
 
4/15/2007            6            9              11          12         38
 
total                     27          30            53          37        147 
 
 
hi all ,
 
i would like to create a sql statement to get the data high lighted in blue... which is the number of part id needed per day... i achived this data through cross tab, but now i need to use this data in groupin ....
 
 
can any one help me in this
thanks


Replies:
Posted By: BrianBischof
Date Posted: 07 May 2007 at 10:06pm
From the looks of it, it appears that you just want the grand total of the balance for every part number across all days? If so....

SELECT Sum(your_field) FROM your_table



-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window