SubReport in the GroupFooter

[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

 

[Duane Hookom]

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

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.

 

[Guest]

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.