Using shared variable between a main report from an sql database and a sub report from an excel data

[jizzycrystal]

Sub report:
I created a formula called YTDFTE
Whileprintingrecords;
shared numbervar ytdxxx := {@YTDxxx}
I then dragged into my sub report

Then in main report
I created a formula called TOTYTDFTE
Whileprintingrecords;
shared numbervar ytdxxx;ytdxxx

I then dragged into main report.

RESULT: IT DIDN'T WORK I JUST GOT 0.00

Question: does the formulae {@YTDxxx} have to exist in both reports?????

Thanks

 

[Charliy]

Be sure that the subreport appears in the main report before the formula that uses its data.

 

[jizzycrystal]

Thanks Charily
when you say "before" do mean in a section before.
The subreport is in the report footer section of the main report

 

[Charliy]

The subreport needs to be in a section above the formula that uses the resuly.

 

[jizzycrystal]

ok thanks!