I have a report with many subreports. I need to changed the page footer based on the current record that is printing in the subreport. I have tried using a shared variable but the value is updated at the completion of the subreport; therefore, if the subreport runs over more than one page or has more than one record the page footer is incorrect.