• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

Alternative for Runningsum

Hi All,

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

Thanks,
0
Subash2023
Asked:
Subash2023
  • 2
1 Solution
 
peter57rCommented:
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
 
mlmccCommented:
What are you trying to accomplish?

mlmcc
0
 
mlmccCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now