Print Page | Close Window

Sum Variable at Report Footer

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=19230
Printed Date: 29 Apr 2024 at 10:14pm


Topic: Sum Variable at Report Footer
Posted By: guy723
Subject: Sum Variable at Report Footer
Date 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}, mailto:%7b@JobSuffix - {@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.
 


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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window