Calculated Controls on a Report

[bkessinger]

Hi All:

I have a report with a subreport. I am performing calculations on a couple of fields (one is on the sub-report and one is a difference between a control on the Main report and a control on the sub-report) and showing them in the group footer. When I try to sum() these controls in the Report Footer, I'm being asked for parameters for these two controls. Please assist. Thanks.

Bill K.

[HansV]

Try the following:

Duplicate the controls in the group footer.
Set the Running Sum property of the duplicates to Over All.
Change the Control Source of the controls in the report footer to simple references to the duplicates, e.g.

=[DuplicateOfBalanceDue]

where DuplicateOfBalanceDue is one of the duplicates in the group footer.

When it works correctly, set the Visible property of the duplicates in the group footer to No.

[bkessinger]

Thank you Hans. That did the trick.