Multi Column Report Headers

I have a report that prints two pages per column. It is very simple, and has
no grouping or sorting levels. Just the report header, page header, details,
and page footer.

I currently have the detail control labels in the page header, but they only
print above the details in the first column of the page. How do I get them
to print above the details in every column of the page?

Thanks,
Diane

On Fri, 3 Aug 2007 08:42:04 -0700, diaare wrote:

I have a report that prints two pages per column. It is very simple, and has
no grouping or sorting levels. Just the report header, page header, details,
and page footer.

I currently have the detail control labels in the page header, but they only
print above the details in the first column of the page. How do I get them
to print above the details in every column of the page?

Thanks,
Diane

In Design View, set the Report width to the full width of the paper
(minus the margins).
Copy and paste the existing column label as many times as you need to,
i.e 1 times if you want to have 2 column header labels.
Move them to their approximate column position in the Page Header.

Then Click on File + Page Setup + Columns.
Uncheck the "Same as detail" check box.
Manually enter the width of the column wanted.

Save and run the report.
The Page Header will span the entire page. Re-position the column
header labels as needed.


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Perfect. I knew it was an easy fix, just not sure where it was. Thanks so
much!

"fredg" wrote:

On Fri, 3 Aug 2007 08:42:04 -0700, diaare wrote:

I have a report that prints two pages per column. It is very simple, and has
no grouping or sorting levels. Just the report header, page header, details,
and page footer.

I currently have the detail control labels in the page header, but they only
print above the details in the first column of the page. How do I get them
to print above the details in every column of the page?

Thanks,
Diane

In Design View, set the Report width to the full width of the paper
(minus the margins).
Copy and paste the existing column label as many times as you need to,
i.e 1 times if you want to have 2 column header labels.
Move them to their approximate column position in the Page Header.

Then Click on File + Page Setup + Columns.
Uncheck the "Same as detail" check box.
Manually enter the width of the column wanted.

Save and run the report.
The Page Header will span the entire page. Re-position the column
header labels as needed.


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail