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
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top