Report 2 pages wide

  • Thread starter Thread starter TC2004
  • Start date Start date
T

TC2004

Hi,

I have a report that needs to extend over 2 pages, i.e. one line per subject
and 15 columns of information that do not all fit on 1 letter-sized page.
Right now I have all the information on 1 page, but the page is larger than
letter size.

How do I deal with this? Is there a way similar to Excel, where one can
repeat the Subject ID (first column) on the second page, so that the lines of
data can be easily identified?

Thanks,
Astrid
 
Hi,

I have a report that needs to extend over 2 pages, i.e. one line per subject
and 15 columns of information that do not all fit on 1 letter-sized page.
Right now I have all the information on 1 page, but the page is larger than
letter size.

How do I deal with this? Is there a way similar to Excel, where one can
repeat the Subject ID (first column) on the second page, so that the lines of
data can be easily identified?

Thanks,
Astrid
Click to expand...

Let's assume your columns look like this:
[ID] [Field1] [Field2] .... [Field13] [Field14] [Field15]
and only columns 1 through 13 fit across one page with [Field14] and
[Field15] on their own page.

Select the [ID] control.
Copy it.
Paste it.
Move the copy of the [ID] between [Field13] and [Field14].

[ID] [Field1] ..... [Field13] [ID] [Field14] [Field15]

The second page will show
[ID] [Field14] [Field15]
 
Hi,

I have a report that needs to extend over 2 pages, i.e. one line per subject
and 15 columns of information that do not all fit on 1 letter-sized page.
Right now I have all the information on 1 page, but the page is larger than
letter size.

How do I deal with this? Is there a way similar to Excel, where one can
repeat the Subject ID (first column) on the second page, so that the lines of
data can be easily identified?

Thanks,
Astrid
Click to expand...

Let's assume your columns look like this:
[ID] [Field1] [Field2] .... [Field13] [Field14] [Field15]
and only columns 1 through 13 fit across one page with [Field14] and
[Field15] on their own page.

Select the [ID] control.
Copy it.
Paste it.
Move the copy of the [ID] between [Field13] and [Field14].

[ID] [Field1] ..... [Field13] [ID] [Field14] [Field15]

The second page will show
[ID] [Field14] [Field15]
Click to expand...

I meant to add.... (If you're using an 8.5-inch width of paper.):

Make sure the last 3 controls (including the 2nd [ID] ) are placed
beyond the 8.5 inch width of the page. Depending upon your margin
settings a bit of trial and error might be necessary to get the 2nd
page to show at the correct left margin position.
 
Back
Top