Need Count of records in Group Header

Posted on 2008-11-17
Last Modified: 2012-05-05
I created a Running Total to count the number of records being displayed for each Group.  It works fine when I place it in the Group Footer, but I would prefer to display it in the Group Header.  Can it be done?
Question by:CarlaGibson
    LVL 26

    Expert Comment

    sure you can.
    just drag the sum from group footer to the group header. since thay are grouped within the same group the result will not change.
    LVL 100

    Accepted Solution

    You can't.  A running total is calculated during the printing pass and will be 0 in the group header.

    Assuming you are counting all records in a group try this
    Right click one of the fields in the detail sectiion
    Click INSERT --> SUMMARY
    Set it as COUNT for the summary type
    Put it in the group footer

    You can drag the summary to the group header.


    Author Comment

    This is no longer needed by the people who requested that I do it.  I have not had a chance to test out the code provided.  I'll give the points to mlmcc for taking the time to answer.


    Author Closing Comment


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 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

    16 Experts available now in Live!

    Get 1:1 Help Now