Home » Developer & Programmer » Reports & Discoverer » SRW.SET_PRINTER_TRAY In 10g.Urgent (Form 10g)
SRW.SET_PRINTER_TRAY In 10g.Urgent [message #336092] Thu, 24 July 2008 14:40 Go to next message
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 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

Anyone has any idea?
Re: SRW.SET_PRINTER_TRAY In 10g.Urgent [message #336719 is a reply to message #336618] Mon, 28 July 2008 15:25 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: SRW.SET_PRINTER_TRAY In 10g.Urgent [message #337019 is a reply to message #336719] Tue, 29 July 2008 12:24 Go to previous message
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:
  


Current Time: Sat Dec 10 05:18:19 CST 2016

Total time taken to generate the page: 0.08154 seconds