Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Sum of groups Post Reply Post New Topic
Author Message
Djavid
Newbie
Newbie
Avatar

Joined: 18 Mar 2008
Location: Netherlands
Online Status: Offline
Posts: 6
Quote Djavid Replybullet Topic: Sum of groups
    Posted: 10 Jul 2008 at 7:06am

Hi all,

Can anyone tell me how to show the sum of every group on a report?
 
thanx


Edited by Djavid - 10 Jul 2008 at 7:08am
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 11 Jul 2008 at 1:22pm

I am not sure which version of CR you are using. I believe CR2008 now can create summaries of groups. However, if you are using an older  version you will probably have to create a manual running total. Essentially you create a shared variable that runs during the  whileprinting pass. You do this by creating 3 formulas and placing them in appropriate places in your report design.

You will create the first formula and probably place it in the report header. This sets the shared var to an initial startnig value.
 
You create a second formula that creates and uses the same shared variable from formula 1 again set to run during the whileprinting pass. You then increment the shared variable typically by adding the summary amount. This would probably be placed in the group footer.
 
Finally your do this all one more time but place this in the report footer and simply declare the shared variable and return it for printing.
 
All of this has been discussed a number of times on the forum, and is in fact somewhat buried yet found in the CR Help file.
 
Hope this helps.
 
Regards,
 
John W.
IP IP Logged
keval300
Newbie
Newbie
Avatar

Joined: 18 Jul 2008
Location: India
Online Status: Offline
Posts: 24
Quote keval300 Replybullet Posted: 18 Jul 2008 at 3:21am
Hi,
 
u will have to create a running total (look at feild explorer) and select the feild of which u need the total.
u can also reset or do some manipulation(if needed)
 
now  save it.
then place it in group footer.
 
ne more  query ,u can get it cleared from me.
 
Enjoyyyyyy  Crystal Reports...
 
Enjoy...
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.