Print Page | Close Window

Running Total in Group Header

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=625
Printed Date: 27 Apr 2024 at 3:43am


Topic: Running Total in Group Header
Posted By: ode2eba
Subject: Running Total in Group Header
Date 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.
 


Replies:
Posted By: EscApe
Date 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?

Posted By: ode2eba
Date 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

Posted By: BrianBischof
Date 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>

Posted By: Avneesh Sharma
Date 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)


Print Page | Close Window