Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Sum of Maximum (fld,condfld ) Post Reply Post New Topic
Author Message
jyensel
Newbie
Newbie
Avatar

Joined: 23 Sep 2008
Online Status: Offline
Posts: 5
Quote jyensel Replybullet Topic: Sum of Maximum (fld,condfld )
     Posted: 23 Sep 2008 at 8:27am

I calculated total mileage by using maximum and minimum values along with a variable to calculate the difference or total mileage.

I need to sum these totals to get a system total.
 
Mileages are grouped by vehicle, day, and route.
 
 
 
IP IP Logged
gherkin
Newbie
Newbie


Joined: 23 Sep 2008
Location: United Kingdom
Online Status: Offline
Posts: 1
Quote gherkin Replybullet Posted: 23 Sep 2008 at 1:07pm
Create a formula which will count the summarized value - this can then be inserted in the design/group line. Finally, create another formula to display the final total at the end of the group/report

Formula1 -
numbervar count_mileage;
count_mileage:=count_mileage+ {your summarized field}

Formula2 -
whileprintingrecords;
numbervar count_mileage;

Hope that helps
IP IP Logged
jyensel
Newbie
Newbie
Avatar

Joined: 23 Sep 2008
Online Status: Offline
Posts: 5
Quote jyensel Replybullet Posted: 25 Sep 2008 at 3:58am
Thank you

Edited by jyensel - 25 Sep 2008 at 5:01am
IP IP Logged
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