Print Page | Close Window

Summing/Grouping records

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22680
Printed Date: 04 May 2024 at 9:17am


Topic: Summing/Grouping records
Posted By: pmjewett
Subject: Summing/Grouping records
Date Posted: 12 Oct 2018 at 6:12am
Hello,

I'm building a report that uses a view that itemizes costs on a PO. So if a distinct PO# has more than 1 component with costs attached to it there will be multiple records returned for that PO#.

For example.
PO#       Total Cost
79135    $33,016.39
79135    $480.38

However in the report I only want to bring in 1 record for that PO# with those 2 costs summed.

PO#           Total Cost
79135        $33,496.77

The Total Cost field is the only field that would be unique in a return of multiple records for a PO.



Can anyone help figure out how to do this?

Thanks!


Replies:
Posted By: kevlray
Date Posted: 15 Oct 2018 at 4:43am
The way that I wold normally do it is to hide the details and put a running total in the Group Footer for the PO#.


Print Page | Close Window