Home » Developer & Programmer » Forms » PRINTING DIRECTLY FROM THE FORM  () 3 Votes
icon9.gif  PRINTING DIRECTLY FROM THE FORM [message #207972] Thu, 07 December 2006 10:28 Go to next message
rcorpus
Messages: 3
Registered: December 2006
Location: Mexico/Monterrey
Junior Member

Hi
I'm try to print a report directly from Forms I mean when I excecute a report I need to it be printing. I use this lines:
ADD_PARAMETER(LIST_ID,'DESTYPE',TEXT_PARAMETER,'PRINTER');
ADD_PARAMETER(LIST_ID,'DESNAME',TEXT_PARAMETER,'//INB/CARTA/'||V_FILENAME);
ADD_PARAMETER(LIST_ID,'DESFORMAT',TEXT_PARAMETER,'NO');

The error that ir shows is REP-0713 Invalid printer name..... specified by parameter DESNAME

Mi printer is on Forms server.
Please helpe.
Ramon.
Re: PRINTING DIRECTLY FROM THE FORM [message #208013 is a reply to message #207972] Thu, 07 December 2006 17:08 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What version of forms are you using? If 6i search this forum for 'run_product'. If 9i/10g then search this forum for 'web.show_document'.

David
Re: PRINTING DIRECTLY FROM THE FORM [message #208015 is a reply to message #208013] Thu, 07 December 2006 17:26 Go to previous messageGo to next message
rcorpus
Messages: 3
Registered: December 2006
Location: Mexico/Monterrey
Junior Member

I'm using Forms 6i
Re: PRINTING DIRECTLY FROM THE FORM [message #208076 is a reply to message #207972] Fri, 08 December 2006 01:40 Go to previous messageGo to next message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Hi,

From Metalink:
You can resolve the problem following these steps:

1 - In Reports Builder you must select Tools-> Parameter Form Builder;
2 - Here you must select Destype and Desname parameters;
3 - Run Report;
4 - When the Parameter Form page appears, you must set
Destination Type=Printer.
This will automatically change the Destination Name parameter
to the Printer Name.
Example : \\RM-PRINT\rm-floor3-04
5 - You must copy this name (CTRL+C);
6 - Then in Forms Builder you must go into trigger that fires the
report.
7 - Paste print name (CTRL+V) into DESNAME parameter.
In this example, the name 'rm-floor3-01' was wrong.
Use '\\RM-PRINT\rm-floor3-04' as shown below.


DECLARE
    pl_id ParamList;
  BEGIN
    Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'No');
    Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'Printer');
    Add_Parameter(pl_id, 'DESNAME', TEXT_PARAMETER,'\\RM-PRINT\rm-floor3-04');
    run_product(REPORTS,'prova.rdf',SYNCHRONOUS,RUNTIME,FILE);
  END;



Now you do not get error REP-713 because you have specified correct the printer name.


Thanks,
Bhujendra
Re: PRINTING DIRECTLY FROM THE FORM [message #208213 is a reply to message #208076] Fri, 08 December 2006 11:27 Go to previous messageGo to next message
rcorpus
Messages: 3
Registered: December 2006
Location: Mexico/Monterrey
Junior Member

It is working!! thanks a lot.
I have a last question, if I would like to print my report in different printer can I use a variable to used like name of printer? I mean if I would like to send my print report to another printer.
Thanks to your advise.
Ramon
Re: PRINTING DIRECTLY FROM THE FORM [message #208460 is a reply to message #208213] Mon, 11 December 2006 00:11 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
As long as you have a valid printer address in the variable then there will be no problem.

David

Upd: Typo - 'value' to 'valid'.

[Updated on: Mon, 11 December 2006 17:00]

Report message to a moderator

Previous Topic: problem with LOV
Next Topic: Forms 9i reports
Goto Forum:
  


Current Time: Fri Apr 26 07:24:36 CDT 2024