Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Running Total in Group Header Post Reply Post New Topic
Author Message
ode2eba
Newbie
Newbie
Avatar

Joined: 25 Jan 2007
Location: Malaysia
Online Status: Offline
Posts: 3
Quote ode2eba Replybullet Topic: Running Total in Group Header
    Posted: 07 May 2007 at 1:57am
Hi all,
 
I've created running total formula based on these:
1) Initial/reset to zero formula (in Group Header)
2) Running formula (in Details Section)
3) Display formula (in Group Footer)
 
But I want to show the Display Formula in the Group Header instead of Group Footer.
 
How can I pass the value to the Header without resetting the amount to zero again?
 
Need guidance, thank you in advance.
 
IP IP Logged
EscApe
Newbie
Newbie


Joined: 13 Nov 2006
Location: Finland
Online Status: Offline
Posts: 37
Quote EscApe Replybullet Posted: 07 May 2007 at 2:13am
Are you using RunningTotal field or have you done yourself those formulas?

If you are using RunningTotal field, you cannot print it on Group Header. Running total calculates values you have printed so far.

Could you use some kind of formula or summary instead?
IP IP Logged
ode2eba
Newbie
Newbie
Avatar

Joined: 25 Jan 2007
Location: Malaysia
Online Status: Offline
Posts: 3
Quote ode2eba Replybullet Posted: 07 May 2007 at 6:17pm

Hi,

I created the formula myself, but seems stucked on how to pass the value to the Group Header (without initializing it to zero again)

Any idea how? Need help, 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 7:06pm
As EscApe said, you can't pass a running total to the group header area. The running total gets calculated as the detail section is being printed. Thus, the group header has already been printed prior to the running total even being calculated. So if you put it in the group header then it will always be zero.
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
Avneesh Sharma
Newbie
Newbie


Joined: 27 Jul 2010
Location: India
Online Status: Offline
Posts: 1
Quote Avneesh Sharma Replybullet Posted: 28 Jul 2010 at 12:02am

Just Create a formula like this

formula = Count ({Field to count},{GroupFieldName})


Just place it in group header section
That's All.

Avneesh Sharma (avnjaani@gmail.com)
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.016 seconds.