CR8 Export to Excel Problem with Calculations

[emallon]

I have a financial report containing a subreport. Using shared variables I pass the subreport numbers back to the main report for use in a simple subtraction calculation. The difference is displayed along side the main report value. The report looks fine in print.
Upon export it apears that the shared value from the previous line in the report is being used in the calculation and not the current lines shared value.

Print Sample:
Store Sales Diff
001 (sub) 120
(main) 120 0
002 100
100 0
------------------------
Export Result:
Store Sales Diff
001 120
120 0
002 100
100 -20
------------------------
Any suggestions would be helpful.

 

[lbass]

Is the sub in its own section with the shared variable calculation in the next section? When exported, is the sub in the correct position or is it wrapping to the next line?

-LB