Report Totals

[Guest]

I have a report called Associated Fund Interest. It has a grand total in the
report footer. I also have a report called Monthly Investment by Fund Less
Associated. This report has four fields: Fund Name, Fund Number, Face
Amount and YTD Interest. The face amount and YTD interest both have grand
totals in this report footer.
I need to be able to take the grand total from the Associated Fund Interest
report and subtract it from the YTD Interest in the Monthly Investment by
Fund Less Associated report. I thought this would be one of the simpler
things of the project but so far it hasn’t been. Any ideas would be
appreciated.
Sue

 

[Guest]

I would not create anything in one report that depends on another report
unless one is a subreport on another.

Consider using queries, codes, subreports, or whatever to pull values to
display in your report, not a separate report.

 

[Guest]

I thought a subreport would be my answer but--Can I hide a subreport and just
use the textbox in the report footer or can I put the subreport somewhere
else besides the detail section?

 

[Guest]

You can place a subreport in any section of a main report. You can set
sections to invisible in the subreport.