Create multiple pages of same report w/different header

  • Thread starter Thread starter swansonray
  • Start date Start date
S

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?
 
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.)
 
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.
 
Thank you. It worked! Also playing w/Grouping and Sorting further I managed
to get the end result I was looking for.

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

Ray Swanson
 
Back
Top