2 level group per report

[Alain]

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

 

[John Spencer]

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

 

[Alain]

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

 

[Alain]

The group footer has no effect at all

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

 

[John Spencer]

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

 

[Alain]

John,

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

Thanks

Alain