New to Crystal - Totaling based on multiple fields

Posted on 2012-08-30
Last Modified: 2012-09-04
Hi All! First time asking something on here.

I'm working on a Crystal Report (CR10) to check how many items were shipped out. So far, what I've done is modified the heck out of an Accounts Receivable Invoice report.

The problem is, were shipping an item (a bulb) with a fixture. For my purposes it's always going to be 1 to 1, but I'm not sure how to pull a total of the bulbs between different items.

So, what I've gotten to so far (which sort-of works)

{ItemNumber}   {BulbNumber}   {Quantity Shipped}   {Running Count}

*note: The running count is based on the ItemNumber, and resets whenever the BulbNumber changes.

The problem with the above is that it's based off of invoice #s. So what happens is the data is sorted properly (item number, then bulb number), but it shows each item number for however many invoices were shipped out.

Item 1    Bulb1     2     2
Item 1    Bulb1     3     5
Item 2    Bulb2     2     2

My goal here is to get only the final "running count" for each bulb. What I was trying was to suppress duplicates on the item field, but it seems like the suppress formulas I've found don't work in CR10.

Does anyone have any suggestions on how to get the information, or even alternate (better) methods of doing it?
Question by:Siiig
    LVL 100

    Expert Comment

    If you don't need that running total just change it to not reset

    If you need it.
    Create a new one
    Right CLick RUNNING TOTALS in the Field Explorer
    Click NEW
    Give it a name
    Choose the buld quantity field
    Set the type to sum
    Evaluate - For Each Record
    Reset - Never


    Accepted Solution

    Hey Mlmcc,

    Thanks for the response. The issue there is that there's no actual bulb count, it has to be based on the item's shipped.

    What I wound up doing was creating a group based on the bulb name, moved the running total above into the group FOOTER, and hid the details section. What I wound up with was a title (based on the bulb name), and a running total for every one of those bulbs that was shipped out.

    Author Closing Comment

    Issue was more my inexperience. After posting I kept drilling into the report and managed to come up with a solution on my own.

    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.

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

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now