Page break if section won't fit entirely on page

[bbrazeau]

I have a report that tracks time spent on jobs. The report has a section for each job# and a footer for each job# where the hours for each entry for that job are sumed. When the amount of line items in the section will not fit on the current page I would like to insert a page break and move the entire section to the next page, but if the section will fit on the current page I would like it to just print on the curent page. I know how to force a page break for every Job#section, but many times there will be only 1 or 2 entries for a particular job during a pay period. It seems a waste to get every Job by its self on a page if in some instances 5 or 6 would fit on 1 page. Is there a way to force a page break, but only if the section won't fit completly on the current page?

[June7]

I am not sure if this is what you want but group sections have a KeepTogether property. I've never investigated it.

[bbrazeau]

Hi June7, Thanks for your response. I have tried "Keep together" does not work. See attached pdf "Time1". I added an extra false entry to make sure a section was going to be partially on 1 page and partially on another as you can see.

[June7]

According to this http://office.microsoft.com/en-us/ac...005187363.aspx should work. Otherwise, doubt can be done. Even if code could manage it would be so complicated. The code would involve counting lines of print. And if there are any variable length fields and textboxes allowed to grow ... need a crystal ball!

[bbrazeau]

Hi June7, My bad. I was trying to set the keep together property through the Property sheet pane of the section of the report. This setting, as best I can figure, merely turns the option to use "Keep together" on or off. To actually apply it to a section you group the section, then use "Grouping and Totals" section under the "Design" tab, click "more" arrow for the group and you have the options of " do not keep group together on one page","keep whole group together on one page", and "keep header and 1st record together on one page".

[paddymx]

Hi June7, My bad. I was trying to set the keep together property through the Property sheet pane of the section of the report. This setting, as best I can figure, merely turns the option to use "Keep together" on or off. To actually apply it to a section you group the section, then use "Grouping and Totals" section under the "Design" tab, click "more" arrow for the group and you have the options of " do not keep group together on one page","keep whole group together on one page", and "keep header and 1st record together on one page".

I am using 2003 and mine is "sorting and grouping". in the properties of the header select "repeat section" along with the keep together property. My detail continues over two pages and a "header" is printed on the second page of the continued Detail.