Learn how to a build a cloud-first strategyRegister Now

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

Crystal Reports Group/ Sum data

Hi, can anyone help with the following. I need to create a crystal report data extract that does the following.

Example 2 rows of data
Row 1 Contains  Row 2 Contains
AAA                    10
AAA                    30
BBB                     25
CCC                      30
AAA                    15
AAA                     25
AAA                     7

What I want crystal to do is to sum/ group all the AAA's and then add the amount of Row 2 showing a total of 87. There are over 500 different refs in row A
I suspect it is very simple but for the life of me can not get it working in Crystal

1 Solution
First of all a question... When you say Row1 and Row2, are they Fields in your database? If yes, what you need to do is:

Insert Group
Select Field1 (the one that contains the Name) as the grouping field
You can add the group total by dragging Field2 (the one with the individual amount) to the group header or footer.

If Row1 and Row2 are "literally" rows in your data source, then the above is not valid.

Let us know.
George_MiltonAuthor Commented:
Great answer, exactly what I needed cheers

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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