|
I am having trouble passing a variable from my sub report back into the main report.
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?
|