Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: SQL Post Reply Post New Topic
Author Message
shamee_banu
Newbie
Newbie


Joined: 15 Mar 2007
Location: Solomon Islands
Online Status: Offline
Posts: 28
Quote shamee_banu Replybullet Topic: SQL
    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
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.