Group and total records by value

Posted on 2006-05-26
Last Modified: 2012-08-13
I am new to crystal reports and am trying to figure out how to make this work. I need a report that selects all money accounts (positive, negative and 0) value. I want to put all the positive accounts first & total them. Then the negative accounts & total them and exclude any account with 0 values. Finally total them all. I have crystal reports 10 and it is all in a single table.


Acct 1      123456      $10.00
Acct 2      789123      $22.00
Acct 3      456789      $12.00
Acct 4      012345      $30.00
Acct 5      987654      -$2.00
Acct 6      765443      -$3.00

Thank you
Question by:carlmahon
    LVL 100

    Accepted Solution

    The easiest way is to create a formula

    Name - MyGrouping
    If ({MoneyField} > 0) then
    Else If ({MoneyField} < 0) then

    Insert a group on that formula

    Add a select formula - Select Expert

      {MoneyField} <> 0

    LVL 4

    Author Comment

    Thanks that worked perfectly.
    LVL 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    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…
    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…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    794 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