Referrencing a Control in a sub report

[Duane]

I need some help. I have been scratching my head on this one for awhile.

I have a Weekly Report that uses a sub report which lists the prisoners for
each days work. The sub report footer has a control that counts the total
prisoners for that day. The Weekly Report lists the jobs for the entire
week, therefore, there are 5 days in which there is a total prisoner count
for each day.

What I am trying to do is have a control in the Weekly Report footer that
will total the number of prisoner for the entire week, but I am not
referencing the control correctly, or it just can't be done.

I hope I have explained this well enoughand I hope someone can help me.

Thanks in advance.

 

[BillCo]

Havent done this in a while so I might be slightly off on the details,
but the solution i've used in the past is something like:

Have a hidden field (lets call it txtHiddenField) on the parent report
which gets and sums the values from the footers of the subreport.

i.e. Set the control source to "=subreportname!FooterControlName.value"
Set the Running Sum property of this field to "Over all".
By the time it gets to the end it has a tally.

In the footer of the report then put your total field with a control
source "=[txtHiddenField]"

Let me know how it works out