OraFAQ Forum: Reports & Discoverer » SRW.SET_PRINTER

Home » Developer & Programmer » Reports & Discoverer » SRW.SET_PRINTER_TRAY In 10g.Urgent (Form 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SRW.SET_PRINTER_TRAY In 10g.Urgent [message #336092]

Thu, 24 July 2008 14:40

mandeepmandy
Messages: 79
Registered: May 2008
Location: USA

Member

I am migrating reports 6i to reports 10g.In reports 6i there is code to select printer tray in Before report trigger using SRW.SET_PRINTER_TRAY.
The same code is not working in 10g.I am not getting any error but it is not picking paper from the desired tray. Instead of it is picking paper from default tray.Please help me to make it working.
I will appreciate early response.

[Updated on: Fri, 25 July 2008 09:16]

Report message to a moderator

Re: SRW.SET_PRINTER_TRAY In 10g.Urgent [message #336618 is a reply to message #336092]

Mon, 28 July 2008 06:57

mandeepmandy
Messages: 79
Registered: May 2008
Location: USA

Member

Anyone has any idea?

Report message to a moderator

Re: SRW.SET_PRINTER_TRAY In 10g.Urgent [message #336719 is a reply to message #336618]

Mon, 28 July 2008 15:25

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Reports Builder 10g Online Help System

SRW.SET_PRINTER_TRAY: procedure that specifies the name of a valid printer tray and can be used to switch to different printer trays as your report formats

Did you specify valid tray names? If you are printing to the same printer as before, I *guess* tray names are the same. But, if the printer has changed, check tray names.

Also, you might try to specify paper type instead of tray name. For example, set the printer's first tray to use PLAIN paper and the second tray to use COLOUR paper. Then, set these values (PLAIN, COLOUR) in the SRW.SET_PRINTER_TRAY built-in.

Report message to a moderator

Re: SRW.SET_PRINTER_TRAY In 10g.Urgent [message #337019 is a reply to message #336719]

Tue, 29 July 2008 12:24

mandeepmandy
Messages: 79
Registered: May 2008
Location: USA

Member

Littlefoot

I don't think there is any issue with the tray name.I tried to print it using paper layout run and it is working good.But on browser it is not picking the desired tray.I think this might give you more on this issue and you can tell me more.
Thanks for reply

**I tried with 'Letterhead' instead of ' Tray 3' and the result is same.

[Updated on: Tue, 29 July 2008 12:26]

Report message to a moderator

Previous Topic:	Oracle 10g: Spreadhsheet output - crams in 1 page.
Next Topic:	How Can be use PL/SQL Procedure In Discoverer..?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 13:59:44 CDT 2024