accumulating numbers in subreport

[Guest]

I have a total qty for a contract in a report.
In a subreport in the detail section I have received qty by dates. How could
I calculate in the subreport detail section in the additional column the qty
left.
Report:
Contract Qty - 2,000
Subreport
Date Received Qty Left Qty (I need this column???)
1/1/05 100 1,900
1/2/05 200 1,700
1/3/05 100 1,600
.....
I'm trying =SUM("Received Qty","qrySubreport","[ContractID]=" &
Reports!Report!ContractID) But, it gives me some incorrect numbers.
Please, advise anything.
Thanks

 

[Marshall Barton]

I have a total qty for a contract in a report.
In a subreport in the detail section I have received qty by dates. How could
I calculate in the subreport detail section in the additional column the qty
left.
Report:
Contract Qty - 2,000
Subreport
Date Received Qty Left Qty (I need this column???)
1/1/05 100 1,900
1/2/05 200 1,700
1/3/05 100 1,600
....
I'm trying =SUM("Received Qty","qrySubreport","[ContractID]=" &
Reports!Report!ContractID) But, it gives me some incorrect numbers.

Add a text box named txtRunRcvd to the subreport's detail
section. bind it to the Received Qty field and set its
RunningSum property to Over All.

Then add another text box to the detail section and set its
expression to:
=Parent.[Contract Qty] - txtRunRcvd

 

[Guest]

Thank you very much, Marshall.
It's working as a song.

I have a total qty for a contract in a report.
In a subreport in the detail section I have received qty by dates. How could
I calculate in the subreport detail section in the additional column the qty
left.
Report:
Contract Qty - 2,000
Subreport
Date Received Qty Left Qty (I need this column???)
1/1/05 100 1,900
1/2/05 200 1,700
1/3/05 100 1,600
....
I'm trying =SUM("Received Qty","qrySubreport","[ContractID]=" &
Reports!Report!ContractID) But, it gives me some incorrect numbers.

Add a text box named txtRunRcvd to the subreport's detail
section. bind it to the Received Qty field and set its
RunningSum property to Over All.

Then add another text box to the detail section and set its
expression to:
=Parent.[Contract Qty] - txtRunRcvd