Assigning Calculated value to main report from subreport

[Ayo]

I have a report with a subreport in it. I am trying to sum up the values of a
txt-box [Extended Price] in the subreport and put the value in a txt-box,
"TotalAmountIS" on the main report. This is what I did:
1.) I created a txtbox in the footer of the subreport and called it
TotalAmount
2.) I assigned "=sum([Extended Price])" to the control source of
TotalAmount
3.) I created a txtbox on the main report
4.) I then assigned "=Nz([subreportname]![TotalAmount],0)" to the control
source of TotalAmountIS
This was the same way I did it on a form, with subform that I used before
but this time around I am getting "#Error". Any ideas what I am doing wrong?

 

[Allen Browne]

See:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html