INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

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

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

(OP)
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

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

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

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

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.

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

How are ya Pack10 . . .

Quote (Pack10)

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.

Do you not have the fields of interest in the country group section?

Your Thoughts? . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? Worthy Reading! thumbsup2
Also FAQ181-2886: How can I maximize my chances of getting an answer? Worthy Reading! thumbsup2

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close