Can I change paper bins? 
Author Message
 Can I change paper bins?

My report will be printing an address page (for a windowed envelope) on page
one, a check on page two, and report data on pages 3 through n.

I was hoping to change the paper bin to use the "preprinted check stock" for
each page 2, and then back to the regular paper for all other pages.  In the
RDC, the Report property is PaperSource.

Two options that I can't get to work:
1) Can I change the Report.Papersource property during the BeforeFormatPage
event when pagenum = 2?  I keep getting Permission Denied errors when I try.
2) Is there a way that I can conditionally set the Papersource directly in
the RPT  - that is, to change the Paper Source to "lower bin" when printing
"page 2"?

Any suggestions would be appreciated.
Thank You



Sun, 12 Jan 2003 03:00:00 GMT  
 Can I change paper bins?
Fred,
    I don't know if you can programmatically change the paper source for
individual pages within a report, but there might be another way.  Have you
tried to set the 'check' into a subreport?  You might be able to change the
paper source for the subreport - given that it is a report object onto
itself.  Just a thought - I have no idea if it will work or not, but it
certainly is worth a shot (far better than trying to figure our what page
you are on in a printjob).

HTH,
--
Dan McGarry
HCI Systems, Inc.
http://www.hcisystems.com


Quote:
> My report will be printing an address page (for a windowed envelope) on
page
> one, a check on page two, and report data on pages 3 through n.

> I was hoping to change the paper bin to use the "preprinted check stock"
for
> each page 2, and then back to the regular paper for all other pages.  In
the
> RDC, the Report property is PaperSource.

> Two options that I can't get to work:
> 1) Can I change the Report.Papersource property during the
BeforeFormatPage
> event when pagenum = 2?  I keep getting Permission Denied errors when I
try.
> 2) Is there a way that I can conditionally set the Papersource directly in
> the RPT  - that is, to change the Paper Source to "lower bin" when
printing
> "page 2"?

> Any suggestions would be appreciated.
> Thank You



Mon, 13 Jan 2003 03:00:00 GMT  
 Can I change paper bins?

Thanks for the idea.  Unfortunately, when I tried it, the Printer Setup
settings are for the container report and all subreports.
Still searching.


Quote:
> Fred,
>     I don't know if you can programmatically change the paper source for
> individual pages within a report, but there might be another way.  Have
you
> tried to set the 'check' into a subreport?  You might be able to change
the
> paper source for the subreport - given that it is a report object onto
> itself.  Just a thought - I have no idea if it will work or not, but it
> certainly is worth a shot (far better than trying to figure our what page
> you are on in a printjob).

> HTH,
> --
> Dan McGarry
> HCI Systems, Inc.
> http://www.hcisystems.com



> > My report will be printing an address page (for a windowed envelope) on
> page
> > one, a check on page two, and report data on pages 3 through n.

> > I was hoping to change the paper bin to use the "preprinted check stock"
> for
> > each page 2, and then back to the regular paper for all other pages.  In
> the
> > RDC, the Report property is PaperSource.

> > Two options that I can't get to work:
> > 1) Can I change the Report.Papersource property during the
> BeforeFormatPage
> > event when pagenum = 2?  I keep getting Permission Denied errors when I
> try.
> > 2) Is there a way that I can conditionally set the Papersource directly
in
> > the RPT  - that is, to change the Paper Source to "lower bin" when
> printing
> > "page 2"?

> > Any suggestions would be appreciated.
> > Thank You



Mon, 13 Jan 2003 03:00:00 GMT  
 Can I change paper bins?

Just got word from Crystal that changing bins by page is not currently
possible.  It's currently an open enhancement request.

Others must be in the same boat.  I was hoping to alternate 'check report,
remittance report' for each Payee in the batch.  The problem with this is
that in an organization this large, it is possible that someone will print
to the same printer while the check run (large batch of checks and reports)
is printing, interjecting a rogue report into the print job.
Ultimately, the only solution is to go back to the old way.  Print all the
checks as one report, all the Remittance reports as another report, and then
have the mailroom staff collate the checks with the reports.
I also tried exporting to Word and writing a Word script to look for the
check pages and change bins, since Word lets you change bins for each
section of a document.  But that got out-of-hand


Quote:
> My report will be printing an address page (for a windowed envelope) on
page
> one, a check on page two, and report data on pages 3 through n.

> I was hoping to change the paper bin to use the "preprinted check stock"
for
> each page 2, and then back to the regular paper for all other pages.  In
the
> RDC, the Report property is PaperSource.

> Two options that I can't get to work:
> 1) Can I change the Report.Papersource property during the
BeforeFormatPage
> event when pagenum = 2?  I keep getting Permission Denied errors when I
try.
> 2) Is there a way that I can conditionally set the Papersource directly in
> the RPT  - that is, to change the Paper Source to "lower bin" when
printing
> "page 2"?

> Any suggestions would be appreciated.
> Thank You



Mon, 13 Jan 2003 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. How to change paper bin in Excel97 with VB5

2. Changing paper bin in the middle of a document

3. How can I change the Paper Bins ?

4. Changing Paper Bins

5. Changing Paper Bin Of Default Printer

6. Changing Paper bins

7. Change paper bin

8. Selecting Paper Bin in Excel 2000 VBA

9. Multiple paper bin usage within the same Word document

10. how to select output paper bin from code?

11. Q: Forcing Printer Paper bins / Getting List Per Printer

12. Printer paper bins enumeration question

 

 
Powered by phpBB® Forum Software