Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Page Breaks

    What would I use for the "condition" when creating a macro to force a page break in this example.

    "Company" is a Group Header
    Contacts for each company are listed under the Company

    On some pages of the report the "Company" and the names that go below it are separated.

    Thanks!
    egghead

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional Page Breaks

    I'm assuming you're talking about a report here. All you need to do is set the keep together property of the group (in the grouping dialog) to "with first detail" to keep the company from printing on a different page.

    If you still want a page break, go into the report's design view, select the group header, and bring up its properties dialog. On the format tab, you'll see the Force New Page property, which you can set to Before Section to insert a page break before each Company.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Page Breaks

    Thank you for reminding me of the Group Properties, that was exactly what I needed. I love it when I use "Help" and get so far off track.

    About the Force New Page Break property: Can you explain why that is different from using the Page Break Tool from the Toolbox and placing it in the Group Header?
    egghead

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional Page Breaks

    It's much more intelligent, for one thing. If you use the property and this is the first group on the first page of the report, it realizes you probably don't want a page break there and ignores it. On subsequent groups, however, it dutifully inserts a page break. The page break control is brute force, while the property represents finesse. <img src=/S/grin.gif border=0 width=15 height=15>
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Page Breaks

    I get it now, thanks! You have a good way of explaining things! <img src=/S/clever.gif border=0 width=15 height=15>
    egghead

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •