• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

New to Crystal - Totaling based on multiple fields

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?
  • 2
1 Solution
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

SiiigAuthor Commented:
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.
SiiigAuthor Commented:
Issue was more my inexperience. After posting I kept drilling into the report and managed to come up with a solution on my own.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now