Summarizing in Crystal Reports

Posted on 2012-09-01
Last Modified: 2012-09-03
I have only started using CR again after a few years and need some general advice.  I have report where i would like to summarise all my purchase order amounts based on criteria which I have already used in another report.

I obviously could create this easily including all the data and then using a running total but I only want to show the summaries and not the detail.  

What is the cleanest way to do this?
Question by:RichardH1976
    LVL 77

    Expert Comment

    I don't really see the relevance of 'another report'- can you explain?

    " i would like to summarise all my purchase order amounts based on criteria which I have already used in another report"

    If you have created your summary totals then just hide the detail section (right click on the Detail label on the left)
    LVL 100

    Accepted Solution


    You can use the existing report.
    Insert the summaries you want into the group and report footers.
    Once inserted you can delete all the fields from the detail section.

    LVL 22

    Expert Comment

    Insert a CrossTab.

    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. …
    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    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…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 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

    26 Experts available now in Live!

    Get 1:1 Help Now