Solved

Crystal Reports Running Total in a Formula

Posted on 2009-03-30
9
525 Views
Last Modified: 2012-06-21
Looking to find out how to write a formula that will calculate the running total of a field and reset on change of a group
0
Comment
Question by:nemesis1210
  • 5
  • 4
9 Comments
 
LVL 6

Expert Comment

by:RPCIT
ID: 24022392
You shouldn't actually have to use a formula unless you want to get fancy. (which sometimes happens)

You can use a RunningTotalField (should show up in your fields list, right click and hit new) .

The running total field allows you to change when you want to evaluate, and when you want to reset.
0
 
LVL 2

Author Comment

by:nemesis1210
ID: 24022613
unfortunatly I need to get fancy, I need to be able to run a calculation on two existing running totals and am unable to do so, so I am hoping to be able to create formulas for these as opposed to running total fields so I can perform my calculation.

Thanks anyhow
0
 
LVL 6

Expert Comment

by:RPCIT
ID: 24022757
You can manually create runnign totals, or "fancy" formulas by adding formula fields to the sections you want..

you could put the reset field in the group header, the increment field in the detail, and the display in the footer.

using something like this in the code:

//begin increase value;

WhilePrintingRecords;

numberVar SomeVal;

SomeVal := SomeVal + {tablName.FieldName}

//end
 

//begin reset value;

WhilePrintingRecords;

numberVar SomeVal;

SomeVal := 0;

//end
 

//begin display value;

numberVar SomeVal;

SomeVal

//end

Open in new window

0
 
LVL 6

Expert Comment

by:RPCIT
ID: 24022768
missing semi-colon (;) on line 4
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 2

Author Comment

by:nemesis1210
ID: 24022952
almost there, values increase during the detail and reset at each group, however display is always zero in the footer
0
 
LVL 6

Accepted Solution

by:
RPCIT earned 500 total points
ID: 24022958
try adding whileprintingrecords; at the top of the display formula
0
 
LVL 2

Author Comment

by:nemesis1210
ID: 24023085
Perfect thank you
0
 
LVL 2

Author Closing Comment

by:nemesis1210
ID: 31564497
Worked like a champ
0
 
LVL 6

Expert Comment

by:RPCIT
ID: 24023842
You welcome :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
dynamically populate report text based on command data 7 49
Crystal Report Date Range Parameters 2 51
Conditional Text in Crystal 4 43
Crystal Report for VS2013 17 71
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now