2 level group per report

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

Guest

Hi,

I have a report that needs to be grouped in 2 level, per country and per
province/state.
My problem is I need to see data on the first page of the first level group
(country)
and the first page of the second level group (province).
I have tried many combination of forcing new page on both level but I cannot
keep the group header of the province with the data when the province change,
meaning I see data in Canada, Alberta and on the same page, I will see the
group header of the next province when it is time to change on the same page.
which I cannot see

If I force new page on the province group. it will be OK but my first
country page will be blank, only the header.

Is it possible to set it up so I can see all data being grouped together,
country all together, province all together and seeing data on the first page
of each country?

Thanks

Alain
 
Have you tried using the group footer to specify when you want a new page
instead of using the group header?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I did not tried it but my group footer are not part of my report
I'll try it and see what comes up

Alain
 
The group footer has no effect at all

John Spencer said:
Have you tried using the group footer to specify when you want a new page
instead of using the group header?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 
You added a group footer and set its Format: Force New Page property to
After Section and that had no effect. That is strange.

Also, did you Set the group header's Force New Page property to None.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
John,

just forgot to set the group header Force New Page to none.
Works the way I need

Thanks

Alain
 
Back
Top