I'm a nb to Crystal Reports and am working on a report for a friend. There is a Main Report and 3 sub reports. The Main report is using a date range to gather information on mainenance records / costs on pieces of equipment. Each pc of equp will have multiple work orders attached to it.

The first subreport lists the work done and the cost of the labor for inhouse maintenance. The second subreport lists the cost of the parts needed. And the 3rd subreport lists any associated costs for parts and labor for work done outside of our organization... ie work from an outside vendor.

Many Thanks to "DBlank" I was able to set up sharedvars to total the buckets in the sub reports, and then pass those values to the main report.

 

The problem I have now is if you are viewing a equp "A's" workorder report, it would show labor of $300.00 on wrk order "1".  On workorder "2" that 300.00 should not be there, but the main report still shows it).  That $300.00 labor charge will remain on the main report until a new labor record is found and sent to the main report to replace it. 

 

This value is will not change until the next subreport value replaces it. I am looking for a way to initialize the total buckets so they will reflect the current workorder being viewed's information, and not something from a previous one.  Unfortunately if the work order has no labor records, the fields are Null, and not zero, so I'm running into problems..... and would appreciate suggestions please... (how do i get myself into these things... lol)

 

thanks

Madman