Crystal Reports subtotalling with variables

Question

Crystal Reports 2016 Support Pack 2 
 I am using variables to do subtotals of values carried forward from a subreport. I have set up the following formulas: 
 Initiation formula: 
 BDG START - whileprintingrecords; currencyvar bdgfrpd; bdgfrpd := 0 FASSOU START - whileprintingrecords; currencyvar FASSOUFRPD; FASSOUFRPD := 0 
 These have been put into the Group Header section and are suppressed. 
 Subtotaling formula: 
 BDG ST - whileprintingrecords; currencyvar BDGFRPD; BDGFRPD := BDGFRPD + {@Sales BDG Paid Freight} FASSOU ST - whileprintingrecords; currencyvar FASSOUFRPD; FASSOUFRPD := FASSOUFRPD + {@Sales Fassou Paid Freight} 
 These have been put into the Detail section and are suppressed. 
 Display of the subtotal formula: 
 BDG ST DISP - whileprintingrecords; currencyvar BDGFRPD; BDGFRPD FASSOU ST DISP - whileprintingrecords; currencyvar FASSOUFRPD; FASSOUFRPD 
 These have been put into the Group Footer section and are NOT suppressed. 
 The subtotals being produced are not correct. In some cases, the last detail lines's value within the group is being added in twice. In other cases, the subtotal is correct but the other subtotal is including the value from the other subtotal. 
 
 I also have formulas to product a grand total set up similarly to these formula for subtotaling and the grand total formula are working fine.

MikeBurch · Accepted Answer

Thanks Django. But it seems that the report is now working without your suggestion. When I could not get the report to work last week I suppressed the group footer section where the 'display' formula was printing. I went back to this report this morning with the intention of putting the changes in you suggested but when I unsuppressed this section, did NOT make the changes you suggested and ran the report the doubling of the last records value no longer happened. I ran the report for various months and the subtotals are now showing correctly each time. I will keep this suggestion for the totaling formula handy though in case I run into this issue again.

Django · Answer

Something like this which will be processed after your sub-report: 
 whileprintingrecords; 
 shared numberVar ValueToSum; 
 shared numberVar GroupSum; 
 shared numberVar GrandSum; 
 GroupSum := GroupSum + ValueToSum; 
 GrandSum := GrandSum + ValueToSum; 
 local numberVar TheValue; 
 TheValue := ValueToSum; 
 ValueToSum := 0; 
 TheValue; 
 
 That's a long way of attempting to solve the issue. So this way if your accumulation formula, above, is somehow run multiple times, it doesn't matter because the "ValueToSum" shared variable is reset by the formula once it is done with it. So you can run this over and over again with no ill effects.

Sage 300

Crystal Reports subtotalling with variables

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING