Shared Variables Issue

[slicknick515]

Hi, I am trying to pass values from a subreport to the main report.
Main report shows current Quantitiy on Hand of a particular product.
Subreport shows Quantity on Hand on a particular date selected.
I want to show the Historical Qunatity from the subreport next to the current Quantity on the main report.
Right now, I have this formula in my main report->
Whileprintingrecords;
Shared NumberVar myTotal;
myTotal
In the subreport, I have this formula->
Whileprintingrecords;
Shared NumberVar myTotal :={QtyonHand}
When i run the report, I get the same value (8.00) for every record. I have no idea where it is getting the 8 from.

Any help is appreciated.

 

[IanWaterman]

YOu must link subreport on product id

Then place your variable eval formula in detail section of Sub Report

If you have not linked SR and place eval formula in Report footer it will only be populated with data from last record found

Ian

 

[lbass]

We need to know in what report section the sub is located and in what main report section your formula that references the variable is located. Also explain whether the sub is linked or not, and if it is, on what field.

-LB