Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Grand total using formula problem Post Reply Post New Topic
Page  of 2 Next >>
Author Message
cyber-guys
Groupie
Groupie


Joined: 02 May 2008
Online Status: Offline
Posts: 42
Quote cyber-guys Replybullet Topic: Grand total using formula problem
    Posted: 27 Jan 2010 at 7:31am

I have a monthly report that summarizes daily cash drawer balances - it subtracts the cash drawer sum from actual sales tickets (via a sub-report) to determine the cash drawer error.

I'm trying to summarize those errors in the report footer but the Summary Expert doesn't display the formula - this is the formula:
 
WhilePrintingRecords;
Shared CurrencyVar cashticket;
Sum ({tblDrawer.Amount}, {tblDrawer.TransDate}, "daily") - cashticket
 
the value cashticket is from the subreport
 
I'm guessing from other posts that summing a sum is a CR limitation
 
Any ideas as to how I can do this?
 
Thanks in advance,
Cyber-guysBig%20smile
IP IP Logged
davejwhite
Newbie
Newbie


Joined: 19 Jan 2010
Online Status: Offline
Posts: 34
Quote davejwhite Replybullet Posted: 29 Jan 2010 at 1:35am
Hi,
 
You're right - you can't sum a sum.
 
Try
1. Sum tblDrawer.Amount - insert into Report Footer as a Grand Total
2. Do a Running Total to sum the cashticket amounts, placing the RT in a Variable
3. Display the cashticket sum from the variable in the Report footer
4. Create a Formula to subtract the displayed cashticket total from the tblDrawer.Amount sum
 
That's what I'd look to do.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 01 Feb 2010 at 1:40pm
or...
 
just build a formula that in effect is your own running total, and you can do as many calculations as you want.
IP IP Logged
cyber-guys
Groupie
Groupie


Joined: 02 May 2008
Online Status: Offline
Posts: 42
Quote cyber-guys Replybullet Posted: 01 Feb 2010 at 3:03pm
I've been trying to do just that to no avail - I'll have some extra time over the next few days to concentrate on it.
 
Thanks,Cyber-guys
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 02 Feb 2010 at 9:20am
I have built 'running totals' in the past when CR cannot do what I need.  Normally I use three forumulas with a shared variable.  The first formula to initialize the variable, the second to do the calculation (very handy if there are complicated conditions for the calculation), third to display the total (i.e, just the variable definition and the variable itself).
 
Hope this helps.
IP IP Logged
cyber-guys
Groupie
Groupie


Joined: 02 May 2008
Online Status: Offline
Posts: 42
Quote cyber-guys Replybullet Posted: 02 Feb 2010 at 9:33am
I'll give it a try - I think my problem is initializing the shared variable
Thanks,
Cyber-guys
IP IP Logged
davejwhite
Newbie
Newbie


Joined: 19 Jan 2010
Online Status: Offline
Posts: 34
Quote davejwhite Replybullet Posted: 03 Feb 2010 at 2:44am
You don't need a Shared Variable, guys - the default Global variable will do.

Also, remember that the sme variable has to be declared in all three formulas:
1. Formula 1 - set the Variable value to := 0. Place this in the section where you want the Running Total to reset
2. Formula 2 - the 'accumulator', with the formula which tells the value what to do
3. Formula 3 - displays the final result.
 
So Formula 1 would look like
 
NumberVar myNumber;
WhilePrintingRecords;
 
myNumber := 0
 
Formula 2
NumberVar myNumber;
WhilePrintingRecords;
 
myNumber := myNumber + {fieldvalue];
myNumber
 
Formula 3
NumberVar myNumber;
WhilePrintingRecords;
 
myNumber
 
 
Hope this helps
 
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 03 Feb 2010 at 7:43am
FYI:  I have issues with global variables from time to time, so I do not use them very often.
 
 
IP IP Logged
davejwhite
Newbie
Newbie


Joined: 19 Jan 2010
Online Status: Offline
Posts: 34
Quote davejwhite Replybullet Posted: 03 Feb 2010 at 8:10am
Is that a 'Global' warning? There's a lot about that in the news right now.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 03 Feb 2010 at 8:16am
Ha Ha Ha :-)
IP IP Logged
Page  of 2 Next >>
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.012 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.