Separate a huge report with color paper?

[Guest]

I am printing a huge report that includes multiple organizations. I need to
insert a page separator of some type (perhaps colored paper) to easily find
each organization. Some of the summaries are 2 pages and some are 40 pages.
Can I place something in the Report Footer that will select a different paper
tray when a condition is met? (Like when the report hits the next
organization, the organizations have unique numbers if this helps Thanks,
Antonio

 

[Duncan Bachen]

I am printing a huge report that includes multiple organizations. I need to
insert a page separator of some type (perhaps colored paper) to easily find
each organization. Some of the summaries are 2 pages and some are 40 pages.
Can I place something in the Report Footer that will select a different paper
tray when a condition is met? (Like when the report hits the next
organization, the organizations have unique numbers if this helps Thanks,
Antonio

You won't be able to control the printer that way, but you could adjust
your report a little bit.

If you create a grouping header based on the organization ID, you can
create your own separator page there. What you'd do is set the group
header to begin a new page, and then the header itself can be sized nice
and large with huge text indicating the name of the company.. maybe an
image or something.. this way it will print at the beginning of each new
Org, and you'll quickly be able to see where the next Org begins.

 

[Parley]

Antonio,
I have a suggestion for you to try.

1. Create a macro that will print your report filtered by Org ID
a. If you have 15 organization ID's you would have one macro that
will print the report 15 times.
b. This will make each Org ID be treated by your printer as a
separate print job.

2. Create a button on a form or switchboard that runs this macro.

3. You printer probably has a setting for separation pages. Set this
to be paper from a secondary tray with the colored paper in your
default printer settings prior to running the macro.

4. Run the macro by clicking on the button that your created.

*Disclaimer*
This is a suggestion that in theory should work but has not been
tested.
I reccomend initially creating the macro to print two or three of your
Org ID's before fully creating the macro and possibly wasting a bunch
of time and paper.

Please respond back to let us know if this worked.

-Parley