Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keeping detail data together on the same page

Status
Not open for further replies.

KerryL

Technical User
May 7, 2001
545
US
A rather detailed report in one of my databases contains header data, sub-header data, detail data, and footer data.

How can I set the report properties so that if the batch of data is too long for the remaining space on a page, it will begin that segment on the next page so that the data isn't split between two pages?

I looked in the FAQ section but didn't see anything on this topic. I also tried report grouping options but couldn't seem to get it to do what I wanted it to do.

kerry
 
This should do the trick.

In the design view of your report, right click and go to sorting and grouping. Select which grouping you want to keep together, and then change the "Keep Together" property located at the bottom of that window to "Whole Group".

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top