Home > IT Answers > Oracle > How can I Send report output to 3 different p...
MAY05659292714
35 pts.
 How can I Send report output to 3 different printer programatically
Oracle 6, Oracle Reports 6i, Oracle Reports
Dear Friends
How can I Send report output to a printer, I have three different printers in three location so how can I Send the report output to those three printer automatically when the user press the print button . please give an example if it is possible
Waiting for your valuable answer.
Best regards
Jamil Alshaibani

Software/Hardware used:
ORACLE Forms [32 Bit] Version 6.0.8.26.0 (Production) AND ORACLE REPORTS R6i
ASKED: Jan 30, 2012  6:38 AM GMT
UPDATED: February 28, 2012  10:47:21 AM GMT
RELATED QUESTIONS
Carlosdl
60,255 pts.
Answer Wiki:
You would need to call the RUN_REPORT_OBJECT (or RUN_PRODUCT) built-in procedure 3 times.

For each call, you would need to set the DESNAME parameter to the name of the desired printer. As you probably know, DESNAME is a system parameter, and you will need to use a Parameter List to send it to the reports engine when calling the report.
Last Wiki Answer Submitted:  Jan 31, 2012  3:27 PM (GMT)  by  Carlosdl   60,255 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

Dear Friends

I am getting this error when I run my report

Starting report GOODS_RECEIVE_REP1 [Sat Feb 04 16:36:18 2012] …
REP-0713: Invalid printer name ‘\Super_vhp’ specified by parameter DESNAME.
End report GOODS_RECEIVE_REP1 [Sat Feb 04 16:36:18 2012].

and my scrip as the following in when-button-pressed trigger

declare pl_id ParamList;
BEGIN
:global.reports_path := ‘C:INVRDF’;
pl_id := Get_Parameter_List(’tmpdata’);
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List(’tmpdata’);
Add_Parameter(pl_id,’DOC’,TEXT_PARAMETER,:IM_GOODS_RECIEVE_HEADER.DOC_CODE);

Add_Parameter(pl_id,’DESTYPE’,TEXT_PARAMETER, ‘PRINTER’);
Add_Parameter(pl_id,’DESNAME’,TEXT_PARAMETER, ‘\Super_vhp’);

Run_Product(REPORTS,:global.reports_path||’GOODS_RECEIVE_REP1.rdf’,SYNCHRONOUS,RUNTIME,
FILESYSTEM, pl_id,NULL);

END;

Bets regards

Jamil

MAY05659292714
 35 pts.
 

you can use the device address or device name to send the print command.

BIllu
 155 pts.