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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record split in two different pages

Status
Not open for further replies.

sregmi

Programmer
Oct 27, 2005
17
US
Hi,

How do I avoid the record split in two different pages.

Say, I have a report where there is a record with a column that has multiple words. If that record happens to be at the bottom of one page (say page no. 5) and splits as some part of the record comes at the bottom of (page 5) and rest at the top of next page (say, page no. 6), is there anyway I could force to have that record printed either at the bottom of the privious page (no. 5) or at the top of the next page (no. 6) instead of having it splited.

I had seen / read somewhere, I think, it is possible. Just could not remember how would it be done. Any help would be highly appreciated.

Regards.....SR
 
I found the solution to it.

In case anyone might need it down the line:

An orphan is a line that falls on the next page when you really
want it to remain with its associated lines on the previous
page. In Microsoft Word, this is equivalent to splitting a
table row across two pages—generally undesirable. For example,
I want to print a class schedule report which lists all students
along with the courses they are taking for each of seven class
periods. Therefore, each student will have seven rows. I want
to keep all seven rows for a student together on the same page
(no orphans). In other words, I don't want three of his periods
at the bottom of one page and four of his periods at the top of
the next page.

In this example, I am grouping by student number to list a
student's seven course periods all together. For example, my
report output will look something like this:
Student 1 Period 1
Period 2
Period 3
and so on to Period 7
Student 2 Period 1
Period 2
Period 3
and so on to Period 7

In these situations, there is a way to prevent orphans in
ReportNet ( I'm using Version 1.1 MR3). It involves a "keep
with header" property but it is only works if properly set up.
My example describes a simple grouped report but it works as
well for master-detail. For a master-detail, the number of
lines to keep with header is the number of lines in your detail
query. The process is as follows:

1. In the List Headers and Footers dialog box, check the header
checkbox for the group item whose multiple rows you want to keep
together (student number in this example). This makes it
visible in your report. This will be our header in the "keep
with header" function. This header can be empty. If desired,
delete any default text item that appears in this header.
2. At the list level, set the list's Column Titles property to At
Start of List. (If you leave this set for At Start of Details,
then this technique won't work.)
3. At the list level, set the list's Pagination property to Keep
With Header. In the box below that checkbox, enter the number
of lines you want to always keep together (7 in this example).
This ensures that if a student starts at the bottom of the page
and there is only room for 5 lines, then the student number
header will be moved to the top of the next page so there is
room for all 7 lines. This is the keep with header function.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top