Hi,

I operate a wholesale business and am working on a report from a table that records transactions (sales, receipts, etc) for all items that I stock. For a given item, each transaction is recorded as a new record, with a transaction ID to differentiate the type of transaction (eg 1 for a Sale, 2 for a Purchase, etc). For my report, I am trying to show Item #, Description, Stock Qty, Qty Sold, and Qty On Order.

My problem is with getting a sum for the Qty Sold and Qty On Order fields. I placed all of the data (Item, Desc, Stock) in the Details section and suppressed duplicates for all so that each item is displayed as a single summary line. For Qty Sold I did a running total (sum) and set to Evaluate on Transaction Type Sale with reset on Group. The data appears correct but displays as though it is showing a list for each transaction (like you would expect a running total to do) so that each item is no longer a single line. What do I need to do to correct these?

This is probably pretty basic but I am still on my 30 day trial and trying to work through in bits and pieces so I can figure out if CR will do what I need. Thanks for any info.

Yes, I did group by Item and it looks okay until I insert the Running Sums for Qty Sold and Qty On Order. These display the full running sums (which I guess I should have expected) when I really only want the final value. It seems like a simple sum would be the correct thing to use, but it doesn't offer me the option to evaluate on a variable like Transaction Type.