Use a value from main report in subreport

[jukus]

I have a billing rate in my main report invoices, and i then have a subreport called labor which can have multiple entries that include hours. I am then wanting to use the billing rate from the main report to get a total sum for the hours times the billing rate. I have tried everything I can think of to try to pull the value into the subreport.

I have used the HasData Method to make calculations from one of my subreports into the main report.

An ideas would be appreciated.

Thanks.

 

[Dennisk]

have you tried referrering to the control on the main report

set a the record source of a calculated control on your sub report like this

=reports!YourmainReport!YourControl

 

[jukus]

That is one thing I have not tried. I'll give it a try.

Thanks

 

[jukus]

worked great. Thanks.