Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Sum Variable at Report Footer Post Reply Post New Topic
Author Message
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Topic: Sum Variable at Report Footer
    Posted: 06 Mar 2013 at 4:33am

Morning guys,

I have a report that use this variable to and need to have a grand total of the last varible to sum it in the report footer. Anyone know how to do that?
 
//Place at Group Header 1
WhilePrintingRecords;
NumberVar EDCValue:=0
 
 
// Place at Group Header 2: @JobSuffix
WhilePrintingRecords ;
NumberVar EDCValue := EDCValue
             + Maximum ({CMI_ORDEREDC.EDC_VALUE}, {@JobSuffix}) ;
EDCValue
 
 
//Place at Group Footer 2:@JobDetail
 WhilePrintingRecords;
      NumberVar EDCValue;
            EDCValue
 
*** Need to have the Grand Total of the Variable 3 in the Report footer.
       please help. ****
 
P.S. I don't have sub report nor need to make one.
 
 
Thank you in advance.
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 06 Mar 2013 at 4:58am
I would modify your @JobDetail formula to something like this:
 
WhilePrintingRecords;
  NumberVar EDCValue;
  NumberVar TotalEDCValue;
  TotalEDCValue := TotalEDCValue + ECDValue;
  EDCValue
 
Then create two new formulas:
//@InitTotal - place in report header
NumberVar TotalEDCValue := 0;
 
//@EDCTotal - Place in report footer.
WhilePrintingRecords;
NumberVar TotalEDCValue;
TotalEDCValue
 
-Dell
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.