Report grouping and page breaks

  • Thread starter Thread starter John Mott
  • Start date Start date
J

John Mott

This sounds simple, but...
I have a dataset that has clinet_id and several different
data fields.

I need the report to page break every time the client_id
changes.

Can someone point me in the right direction?

John
 
John said:
This sounds simple, but...
I have a dataset that has clinet_id and several different
data fields.

I need the report to page break every time the client_id
changes.
Click to expand...

Create a group (View menu - Sorting and Grouping) on the
clinet_id field. Enter Yes in the group's header property.

Set the header section's Height to 0 and set its Force New
Page property to Before Section.
 
Thanks. That almost did the trick. I get the report to
break properly, but now the report title is on first page
with no detail records printed, and the subsequent pages
have teh detail, one client_id per page, but no headings.
Got any suggestions?

Can you tell me why we set the ehaders section height to
zero?
 
John said:
Thanks. That almost did the trick. I get the report to
break properly, but now the report title is on first page
with no detail records printed, and the subsequent pages
have teh detail, one client_id per page, but no headings.
Click to expand...

The force new page causes the report header (your title?) to
be on a page by itself. If you don't like that and do not
have a report footer, then try using the group footer
instead of the group header and setting the footer's
ForceNewPage to After Section

Alternatively, you might want to consider adding the Page
Header section to the report and place the title and heading
labels there instead of in the report header.
Can you tell me why we set the ehaders section height to
zero?
Click to expand...

Because you did not have anything to display there and I
thought it would be a waste of paper to display a blank area
at the top of each group. If you do have something to
display at the beginning of each group, set the height to
whatever you need and add the appropriate controls.
 
Back
Top