Grouping report is not working -- giving me one group field per page

[Pack10]

I am developing a report based on Country and Business Unit, A country can have multiple business groups.
Currently, I am getting one country per page, and i would like to group the countries so i can have the
multiple business units on one page. I tried grouping the report by business unit but it still gives me one page per country -
business unit. What am i doing wrong, or what do i need to do? thanks

Data Sample:
Country Bus Unit 2012 2011 2010
Hong Kong PC 120,000 126,500 134,000
Hong Kong ILGW 55,000 115,000 122,500

 

[dhookom]

There are lots of section, sorting, and grouping properties that determine page breaks. Have you checked them all?

Why are you even grouping by business unit? Your only requirement seems to be one page per country.

Duane
Hook'D on Access
MS Access MVP

 

[LaurieHamlin]

If I understand correctly, all you have to do is:
1. group on country
2. in the group footer properties, set the Force New Page property to After Section

I hope that helps.

 

[TheAceMan1]

How are ya Pack10 . . .

[blue] I am getting one country per page, and [purple]i would like to group the countries so i can have the
multiple business units on one page.[/purple][/blue]

Do you not have the fields of interest in the country group [blue]section?[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]