How do I call an Oracle Report that has a parameter form before running it?
I have many Oracle Reports 6i reports that have a parameter form that I'd like to maintain. I have found guides on passing the parameter form values to the report but I'd like to be able to prompt the user for them.
Below is a trigger I'm using to launch a report which works. This report has a parameter form that is not presented to the user.
declare v_report_id Report_Object; v_report_server_job varchar2(100); v_report_status varchar2(100); v_job_id varchar2(100); v_report_server varchar2(100) := 'rep_wls_reports_apollo'; v_report_url varchar2(100) := 'http://apollo:9002/reports'; begin -- the object name in the Form under the Reports section v_report_id := find_report_object('REPORT130'); -- The report filename in /data/reports12c -- If the report exists elsewhere Teddy must grant the reports server read access to it set_report_object_property(v_report_id, REPORT_FILENAME, 'ripple_trials_centres.rep'); set_report_object_property(v_report_id, REPORT_COMM_MODE, SYNCHRONOUS); set_report_object_property(v_report_id, REPORT_DESTYPE, CACHE); set_report_object_property(v_report_id, REPORT_DESFORMAT, 'PDF'); set_report_object_property(v_report_id, REPORT_SERVER, v_report_server); set_report_object_property(v_report_id, REPORT_OTHER, 'userid='||get_application_property(username)||'/'||get_application_property(password)||'@'||get_application_property(connect_string)); v_report_server_job := run_report_object(v_report_id); v_job_id := substr(v_report_server_job,instr(v_report_server_job,'_',-1)+1); v_report_status := REPORT_OBJECT_STATUS(v_report_server_job); IF v_report_status = 'FINISHED' THEN WEB.SHOW_DOCUMENT(v_report_url||'/rwservlet/getjobid'||v_job_id||'?server='||v_report_server, '_blank'); ELSE message('Report failed with error message '||v_report_status); END IF; end;