Multi Column Report Headers

G

Guest

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
 
F

fredg

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.
 

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

Top