section breaks in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

How do i format my report so that a section will not be split between two
pages of a report? For example:

Report 1 looks like this:

Location 1
tenant 1
tenant 2

Location 2
tenant 3
tenant 4
.....

How do i format the report so that all tenants of Location 2 are on the same
page and are not split between two pages . Something like an auto section
break?! Thanks!
 
Open the report in design view. Open the Sorting and Grouping box. In the
"Keep Together" box select "Whole Group."

Regards.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing mailing labels with multiple recipient name records associated with a single address 5
Adding records - automatic numbering with two primary keys 2
IF THEN statement??? 3
Question about White Space 6
Query/Report Output Based on Current Record in a Form 3
ListBox & TextBox Save 2
More apostrophe nightmares 1
Excel base year add up escalation problem.... 1

Back
Top