Crystal Reports Group/ Sum data

Posted on 2012-08-17
Last Modified: 2012-08-17
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

Question by:George_Milton
    LVL 13

    Accepted 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.

    Author Closing Comment

    Great answer, exactly what I needed cheers

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now