Hello everyone,

I was hoping the function I need would be possible in Crystal Reports 8.5.

I have a purchasing report that groups parts that need to be ordered by part number. Inside that component part number is a list of different production orders that the part is allocated to. This report takes the quantity currently on hand, subtracts the quantity needed for the production order, and specifies when parts need to be re-ordered based on lead times.

The problem I seem to be having is that I can't figure out how Crystal handles equations on items in a group.

It's kind of hard to explain so below is a link to a screencap of my report:
http://www.mediafire.com/i/?ggymmngdzdn

Under the heading "On Hand", I want the value of "Qty Required" to subtract the amount "On Hand" progressively through each line and display to the right of the "Qty Required" value. For example:

Line 1 - Qty Req'd: 75 // On Hand: 35   Total: 40
Line 2 - Qty Req'd: 75 // On Hand: -5    Total: -5
Line 3 - Qty Req'd: 50 // On Hand: -40   Total: -45

The reason I want this is so that if the "Total" number is below 0, it would trigger the "Order By" column so that the purchaser is aware they need to be ordered.

Is this possible? Would I use some sort of a running total field? My knowledge of Crystal is still "in progress" so any help would be greatly appreciated.


Thanks!



Edited by barfnuts - 12 Apr 2010 at 3:24pm