Invoice Rolling Up Values
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22645
Printed Date: 23 Apr 2024 at 6:15am
Topic: Invoice Rolling Up Values
Posted By: BrendanB
Subject: Invoice Rolling Up Values
Date Posted: 18 Jul 2018 at 7:16pm
Hi,
I have an invoice where we need to "roll up" the all the lines into one line.
From something like this:
Item Description Qty Price Total
-----------------------------------------------------------------------------------------------------------
12345 Item A 1 100 100
23345 Item X 2 150 300
76345 Item ZZ 1 750 750
87345 Item KA 5 50 250
-----------------------------------------------------------------------------------------------------------
To this:
Item Description Qty Price Total
-----------------------------------------------------------------------------------------------------------
12345 Item A 9 1050 1400
-----------------------------------------------------------------------------------------------------------
Basically, I would like to "Print" the first line, but keep summing up the subsequent rows to arrive at a final total.
I have looked at Running Totals, but this only works on lines that are visible (printed)
Regards
Brendan
|
Replies:
Posted By: DBlank
Date Posted: 19 Jul 2018 at 2:29am
Is there some sort of grouping or is this for all the rows that are n the report?
If there is no grouping then you can use the report header. Just place the Item and Description field directly into it and it will display the value from the first row. Then just do a SUM on each of the other fields and display those sum summaries in the header too.
The same idea applies to groups but use the group header as your display option. I just can't tell what value you would be grouping on.
|
Posted By: BrendanB
Date Posted: 22 Jul 2018 at 2:07pm
Hi DBlank,
Thanks for your suggestions. This report is based on a SAP B1 invoice, and there are many groups and sub-reports in the report.
I will let you know how I get on
regards
Brendan
|
|