SubReport in the GroupFooter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a report with two group levels: first is Dept Name, second - Person Name.
In the details section I put information about services rendered to the person sorted by date.
In the footer of Dept level I want to put subreport showing summarized services for each person, but for some reason it shows me only the last person name.
I've tried different links, but nothong works.
Any ideas?

Thanks
 
To get what you describe (summary of all persons in the group), you need to
create a totals subreport that you can place in the Dept group footer. Then
set the link master/child fields to your Dept field.

--
Duane Hookom
MS Access MVP


Callisto said:
Hello,

I have a report with two group levels: first is Dept Name, second - Person Name.
In the details section I put information about services rendered to the person sorted by date.
In the footer of Dept level I want to put subreport showing summarized
Click to expand...
services for each person, but for some reason it shows me only the last
person name.
 
That's exactly what I was trying to do. The problem I have is that when I set the master/child link to Dept field and go to preview- main report freezes.
When I set master/child link to Dept and Person I see only the last person in the subreport.
 
Back
Top