Putting Values from Sub Report on the Main

[Thecherub]

I have a Report that Contains 2 sub reports. Is there a Vay to put one of of the values from the sub report into a unbound field on the Main report?

The way things are listed right now the Main report lists FirstName, LastName, Vacationelegibity.

The two sub repoorts List, Time Off History and Time Off Current.

With the colums Being Time Off Booked, Count of TimeOffBooker, and the Dates. With a Sum of the seperate types (loa, low, Vacation) I need to put the sum of just the Vacation in the Main report for both history and Current.

 

[Rich]

Search here for trhe HasData method, examples have been posted

 

[Thecherub]

HasData

Rich

Ok i've tried searching HasData but nothing seems to match my problem.

My sub reports are a list of Types of Time Off (vacation. LOA. LOW)
and a count. With a Sum of the count in the Time Off Booked footer.

I need to pull only the Vacation Sum from the footer and transfer it to the main report.

I've tried "=([Time Off History Subreport].[Time Off Report].[HasData], [Time Off History Subreport].[Time Off Report]![Vacation])

but all that get's returned is "#Name?"

what am i doing wrong here?