Create multiple pages of same report w/different header

[swansonray]

I have created a one page report that I want to print three copies of.
Each copy having a slightly different header.
ie.. store copy
customer copy
managers copy

Is this possible?

 

[Allen Browne]

Create a table with 2 fields:
CopyTypeID Number primary key
CopyType Text required, unique

Enter 3 records:
1 store copy
2 customer copy
3 managers copy.

Create a query using both your existing table(s) and the new one. There must
be no line joining the new table to the other ones in the upper pane of
query design. This is alled a Cartesian product, and gives you 3 copies of
every record.

Make this query the source of your report. Set up a new group header, with
the CopyType field at the top of the page (i.e. page break before this
section.)

 

[KARL DEWEY]

UNTESTED
This should work. Create a new table with field names CopyTitle and enter
the copy names in the field.
Add the table to your report source query without joining. Add CopyTitle to
output.
In report click on Grouping and Sorting and add group header with CopyTitle
ijn the header. Force new page.

 

[swansonray]

Thank you. It worked! Also playing w/Grouping and Sorting further I managed
to get the end result I was looking for.

Ray Swanson