Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Grand Total in report footer Post Reply Post New Topic
Author Message
1misfit
Newbie
Newbie


Joined: 17 Apr 2013
Location: Canada
Online Status: Offline
Posts: 3
Quote 1misfit Replybullet Topic: Grand Total in report footer
    Posted: 18 Apr 2013 at 7:12am
I am a newbe to CR and need some help
I have a report where I am calculating the cycle time of a part using running total Fields.  The report is grouped by work order sequence.  I am trying to summarize the total cycle time to make the part, hence add up the cycle times from all the groups/work order sequences.  When I write the formula, i get the following error: this Field cannot be summarize", can someone point me in the right direction.
 
Thanks
Ryan
IP IP Logged
Niraj
Newbie
Newbie


Joined: 18 Apr 2013
Location: India
Online Status: Offline
Posts: 1
Quote Niraj Replybullet Posted: 19 Apr 2013 at 12:20am
Hi,
you can add in a formula using variable.
For example:
if you want to add a formula say @XYZ then

create one formula say @PQR

whileprintingrecords;// in the formula//
NumberVar PQR;
PQR:= PQR + @XYZ;

Place this @PQR formula in detail section and footer section where you want to display the summary. You must reset the value of the variable PQR at the group header.

Using below code,

whileprintingrecords;
NumberVar PQR:=0;


I am sure this will work out.
Thanks
IP IP Logged
1misfit
Newbie
Newbie


Joined: 17 Apr 2013
Location: Canada
Online Status: Offline
Posts: 3
Quote 1misfit Replybullet Posted: 19 Apr 2013 at 1:23am
Thank you for replying,
I have tried this formula out already, it gives me an error highlightlighting the @avg cycle time formula.  Below is what I wrote:
 
whileprintingrecords;
NumberVar x;
x:= x + {@Avg cycle time};
 
The @avg cycle time is a formula where I am taking two running total feilds and dividing them by a third running total feild.  This gives me the number for each group that is created.  i am trying to add up all the groups to give me an overall cycle time of the part.  This is where i am having the issue.  I cannot seem to figure out how to add up all the numbers generated by the @avg cycle time formula
 
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.000 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.