Main Report is a Change Order

  * Group 1 = Project Number

  * Group 2 = Contract Number & Change Order Number

 

The Sub Report is a different Budget Breakdown of the Change Order amounts

  (1) I have tried using Running Totals to assign the variables. This works if I only want to view the variable but not when I need to use it for a calculations in the main report

     Sub Report

      WhilePrintingRecords;
      If GroupName ({Contracts_10_ttx.Budget~Group5}) = '01'
          Then CurrencyVar OriginalMain := {#Originals};

 

     Main Report

      WhilePrintingRecords;
      shared currencyvar OriginalMain;
      OriginalMain

 

  (2) I have tried calculating the variable on each record. This also works for viewing only but not when I need to use it in calculations in the main report

 

  (3) I have tried putting the sub report in Group 1 header, Group 2 header and Group 2 footer in a higher section than where I need to use the variables, none works for calculations

 

I don't know what else to try. Can anyone help?

 

  Shared currencyVar OriginalMain;
  Shared currencyVar OriginalSub01;
  Shared currencyVar OriginalSub02;

 

Any other suggestions?