How to print subtotal in body of report, based on last occurance of item number
Posted on 2009-07-06
I use Dynamics GP 10, and Crystal Reports 2008 to print my sales documents (via Forms Printer from Accountable Software). I'd like to be able to print a subtotal in the body of the sales quote form, based on the last occurance of a certain item number.
For example, I have a large quote that references several areas of a building. I would like to show a subtotal for each area. The last line item in each area is a part number called "ROOM". This part number signifies the end of the equipment for that room.
Any help you can provide is greatly appreciated!