Counting results in Crystal Reports 11

Posted on 2010-01-06
Last Modified: 2012-06-27
I have a report built in Crystal Reports.  The field "Report_Group" has several possibilities.  I'm trying to use a formula field to count the number of times the data field = "Busies" to use within the report header.  I keep getting the error "There is an error in this formula.  A group condition is not allowed here."   Can anyone help?  I've attached the formula.
Count ({LU_Results.Result_ID},{LU_Results.Report_Group},"Busies" )

Open in new window

Question by:OB1Canobie
    LVL 13

    Accepted Solution

    You have to  create a formula as follows

    if({LU_Results.Result_ID} = "Busies")then

    Then use the SUM of this formula where you want the count displayed

    Author Closing Comment

    This worked.  Great answer.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    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…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    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…

    745 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