Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design
Message Icon Topic: Invoice Rolling Up Values Post Reply Post New Topic
Author Message
BrendanB
Newbie
Newbie
Avatar

Joined: 05 Sep 2014
Online Status: Offline
Posts: 2
Quote BrendanB Replybullet Topic: Invoice Rolling Up Values
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8937
Quote DBlank Replybullet 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.
IP IP Logged
BrendanB
Newbie
Newbie
Avatar

Joined: 05 Sep 2014
Online Status: Offline
Posts: 2
Quote BrendanB Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.