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;