Sunday, February 5, 2017

Oracle Forms 6i. My issue is that I want generate the report directly into a PDF format without demand me which output format




I have a report that I called from Oracle Forms 6i. My issue is that I want generate the report directly into a PDF format without demand me which output format I want.below the code used to call and generate the report from Oracle forms (trigger WHEN_BUTTON_PRESSED):

DECLARE 
p_list PARAMLIST
;
BEGIN
p_list
:=CREATE_PARAMETER_LIST('TEMP');
ADD_PARAMETER
(p_list,'PARAMFORM',TEXT_PARAMETER,'YES');
ADD_PARAMETER
(p_list,'ep',TEXT_PARAMETER,':exer');
ADD_PARAMETER
(p_list,'cc',TEXT_PARAMETER,':code');
ADD_PARAMETER
(p_list,'op',TEXT_PARAMETER,':ordr');
ADD_PARAMETER
(p_list,'nume',TEXT_PARAMETER,':nume');
ADD_PARAMETER
(p_list,'DESTYPE',TEXT_PARAMETER,'SCREEN');
RUN_PRODUCT
(REPORTS,'D:\Reports\MyReport6i.RDF',SYNCHRONOUS,RUNTIME,FILESYSTEM,p_list,null);
IF NOT(ID_NULL(p_list)) THEN
DESTROY_Parameter_List
(p_list);
END IF;
END;

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...