Solved

Crystal Reports Running Total in a Formula

Posted on 2009-03-30
9
528 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 6

Expert Comment

by:RPCIT
ID: 24022768
missing semi-colon (;) on line 4
0
 
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

777 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