printing 3 copies of report with headers original/1stcopy/2ndcopy

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Hi,

I like to print 3 identical copies of a report
I want to print on the first copy the word "original"
on the second copy "1st copy"
and on the third copy "2nd copy"
What is the easiest way to print this in one hit ?

Thanks in advance for your help

Ron.
 
Ron said:
I like to print 3 identical copies of a report
I want to print on the first copy the word "original"
on the second copy "1st copy"
and on the third copy "2nd copy"
What is the easiest way to print this in one hit ?
Click to expand...

Create a table named ReportCopy with one text field named
Header. Then add three records with the text you want in
the Header for each copy.

Next, create a query that includes this new table along with
your original table/query and make sure there is no Join
line between the two tables. Drag the Header field down
into the query's field list along with all the fields in the
original table.

Now, change the report's record source to this new query and
add a top level group based on the Header field. Add a text
box (bound to the Header field) into the header section and
set the group header section's Force New Page property to
Before Section.

If that gets you close to what you want, post back with any
gotchas that come up (e.g. page numbers?).
 
Marsh

Tried your suggestion but this will not work on my report.
The only way is to set the Details group header section's Force New Page
property to
Before Section.
Then only one record will be printed. I need more records to be printed in
this section
Another solution ??
Thanks in advance for your help
Ron
 
Ra said:
Tried your suggestion but this will not work on my report.
The only way is to set the Details group header section's
Force New Page property to Before Section.
Click to expand...

You were supposed to set the new Header field group's header
section's Force New Page. Make sure you added the new group
at the top of the Sorting and Grouping list.
 
Marsh

Yyess !!!

In my report I had to add also a footer levelgroup (After section)
now it runs and
this is exactly what I need

Thanks a lot for your assistance
Ron
 
Ron:

If you stop by our web, and look in the free files area for a db file called
"Other Report Samples", there is an example report contained in that
database showing an implementation of the method discussed by Marsh in his
post. Possibly that will help you with your report.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


Ra stolk said:
Marsh

Tried your suggestion but this will not work on my report.
The only way is to set the Details group header section's Force New Page
property to
Before Section.
Then only one record will be printed. I need more records to be printed in
this section
Another solution ??
Thanks in advance for your help
Ron
Click to expand...
 
Back
Top