Solved

Alternative for Runningsum

Posted on 2011-02-14
4
463 Views
Last Modified: 2013-11-16
Hi All,

I would like to is there any alternative menthod for runningsum instead of using running sum function?

Thanks,
0
Comment
Question by:Subash2023
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 34888434
I am assuming you are using Crystal Reports.

Yes you can do your own running sum instead of using a running totals field.

Basically you have 3 formula fields.

Report header...initialise the variable

whileprintingrecords;
numbervar myrunningsum:=0;
""


Detail line...accumulate the sum

whileprintingrecords;
numbervar myrunningsum;
if <somecondition is true> then
myrunningsum:=myrunningsum + {table.field};
""

In the report foooter..print the value

whileprintingrecords;
numbervar myrunningsum;
myrunningsum


If you have a grouped structure you might want to modify this pattern to use group header and footer instead of report header and footer.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34888816
What are you trying to accomplish?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35163507
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
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

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…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

911 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

26 Experts available now in Live!

Get 1:1 Help Now