Post Author: testing123
CA Forum: Crystal Reports
Hi,
I have a database structure like this:
Project --> LabourTimesheet, PurchaseOrder
Each project may have any number of LabourTimesheet values, and any number of PurchaseOrder values. They are both monetary values.
One project could have 4 LabourTimesheet values, and 3 PurchaseOrder values. Another could have 17 LabourTimesheet values and 200 PurchaseOrder values.
What I want to do is have individual total of the LabourTimesheet and PurchaseOrders for each Project. As it stands now, I can calculate a running total (for each Project) of PurchaseOrders fine. However, the LabourTimesheet values repeat every time a new PurchaseOrder is generated.
We end up, typically with something like this:
Because the LabourTimesheets repeat I cannot set up a standard running total to calculate on each individual timesheet because the entries repeat. Does anyone know of a formula or other method I can use to stop this happening?