accumulating numbers in subreport

A

Alex

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
 
A

Alex

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

Marshall Barton said:
Alex said:
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.
Click to expand...


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
Click to expand...
 
Top