I have a report with a subreport. In the subreport I created a shared variable I want to carry over to the main report:
Shared NumberVar SubAvgPerformed;
SubAvgPerformed :={@AvgPerformed};
I included this formula in the sub report and suppressed it.
I my main report I have the following formula to bring in the shared variable:
Shared NumberVar SubAvgPerformed;

I now have a formula using this value to show a variance on the main report:
{#Drive_ProcedureProjection} - {@SubAvgPerformed};
This last formula is placed in a group footer below where the sub report is showing/calculating the values.

All is working fine except when I get to a record where there is no value in the sub report. When this happens I get the value from the previous record for my shared variable. So... my question is how to I clear/reset the shared variable after each record?

Flanman

Worked like a charm. I was trying to do something similar, but I was trying to put the reset formula in a footer below instead of the header above which was not working. Thanks for the help.