Print Page | Close Window

Help needed Running Total

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=10264
Printed Date: 31 Mar 2025 at 12:35am


Topic: Help needed Running Total
Posted By: Wim Rippen
Subject: Help needed Running Total
Date Posted: 15 Jun 2010 at 8:23pm
I have a report in CR dev. with ACT2010Prem.database.Works fine
 
I have GroupHeader Contact.Company.
 
In DETAIL
 First  subreports Product 1 where @CFR represents a value
 (say 1000)
Second subreport Product 2 where @CFR represents an other value
(say 2000)
 
I see running the report : 1000
and                                    2000
 
 
Now I want a formula/runn total  to have in ( footer ) the result 3000
Which formula's and where to put them. ???
 
Thanks to everybody helping me !
William


Replies:
Posted By: lockwelle
Date Posted: 16 Jun 2010 at 4:07am
I would use shared variables...In the same section as the subreport is running, I would increment the variable by the amount that the subreport is displaying, then in the group footer, I would display the variables value, and in the group header would set it to 0.
 
It's a manual way of doing a running total, but for some reason, running totals don't make sense to me.
 
HTH

Posted By: Wim Rippen
Date Posted: 16 Jun 2010 at 7:29am
I appreciate your comments,but I am just a beginner,so please be
more specfic
what shared fields ( Like WhilePrintingRecords,sharedVar XXX; ???)
how to add them  ( XXX-1,+ XXX2 ???) or simlar
where to place
I have in ONE detail part, T W O sections : Prod1 and Prod2
In Prod 1 value 1000
In prod 2 value 2000  ( as examples)
 
how to get the result 3000 ?? where to put the formulas.
THANKS!!!
William


Print Page | Close Window