I'm a newb to Crystal Reports and I'm tring to work 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.

 

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.

 

I've been able to figure out how to do totals for the cost associated with each subreport. What I would like to do is get grand totals for the report of all the total costs from the subreports. (ie : totals for all labor, totals of all parts, and outside vendor. )  Is there a way to set up a grand total field in the reports main footer?  Coding involved?

 

thanks

Madman

You create them in the sub reports and

set them = to the summary value

then pass that values to the main report

in the main report footer you can add the 3 formulas together.

 

many thanks in advance...

 

madman

 

 

thanks much!!!

 

 

Madman