Using values from a subreport in the main report

[mose Mbugua]

I have made a report from a query and added a sub report created from a different query. The main query has a calculated field so is the sub report. i want to subtract the totals in the sub report from the totals in the main report. Is there a way to doing this?

[jforbes]

Usually the easiest way to do this is to include the calculation that is being done on the SubReport in your Main Query. You can also perform the Subtraction as part of the Main Query.

I tend to perform all my Report calculations in Queries, then use the Report for formatting of information only. It makes things easier in the long run when the calculations and reporting are segregated.

[twinnyfo]

I am with J.... Calculate in your queries, format in your reports.