Oracle Forms (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center