Reputation: 3
--- Print Code in oracle form after Push button Pressed
PROCEDURE PRINT_1 IS
report_id REPORT_OBJECT;
ReportServerJob VARCHAR2(254);
BEGIN
report_id := find_report_object('REPORT191'); ---Reportobejct with set .rdf path
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_DESFORMAT, 'PDF');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'localhost:9002/reports/rwservlet?');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'transaction.tran_id='|| :TRANS_CUST.tran_id || ' paramform=no');
ReportServerJob := run_report_object(report_id);
END;
-- http://localhost:9001/forms/frmservlet?config=webstart (localhost Url)
--In report Builder the preview of myreport is ok but when call from oracle form 12 c its show me subject error.
Call oracle reports from oracle form with one parameter
Upvotes: 0
Views: 1328