I have a main report with multiple sub reports. The main report references bound textbox controls on the various subreports with the Running Sum option set to Overall. (There is nothing in common between the various subreports).
Problem
The controls on the main report display the first/top value for the referenced subreports when using acViewPreview instead of the total (bottom) value. However if I use acViewReport, the controls show the correct total value for Running Sum. But if I print the report using this view, it reverts to the top value instead of the total.
How can I make this work? I'm open to alternatives. I've tried requerying the main report controls and exporting to PDF after opening with no resolve.
Problem
The controls on the main report display the first/top value for the referenced subreports when using acViewPreview instead of the total (bottom) value. However if I use acViewReport, the controls show the correct total value for Running Sum. But if I print the report using this view, it reverts to the top value instead of the total.
How can I make this work? I'm open to alternatives. I've tried requerying the main report controls and exporting to PDF after opening with no resolve.