Skip to Content
0
Former Member
Sep 17, 2007 at 01:55 PM

One to many data display problem.

26 Views

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?