Home » Developer & Programmer » Reports & Discoverer » Running Reports thru Forms(Developer 2K)
Running Reports thru Forms(Developer 2K) [message #89086] Mon, 01 September 2003 10:56
Monika Singhal
Messages: 1
Registered: September 2003
Junior Member
Hello there,

For running report thru form(developer 2k), I am using following code :

PROCEDURE proc_run_report (p_report_name IN VARCHAR2, p_param_list IN paramlist)
IS
v_report_id REPORT_OBJECT;
v_report VARCHAR2 (100);
v_reports_server_url VARCHAR2 (500);
v_reports_server_name VARCHAR2 (100);
v_stmt_no NUMBER;
v_err_place VARCHAR2 (20) := 'proc_run_report';
v_current_error NUMBER;
BEGIN
-- fetch environment variables from server
tool_env.getvar ('REPORTS_SERVER_URL', v_reports_server_url);
tool_env.getvar ('REPORTS_SERVER_NAME', v_reports_server_name);

-- find report object and set REPORT_SERVER property

v_report_id := find_report_object (p_report_name);

set_report_object_property (
v_report_id,
report_server,
v_reports_server_name
);

-- run report, with or without parameter list

IF NOT id_null (p_param_list)
THEN
v_report := run_report_object (v_report_id, p_param_list);
ELSE
v_report := run_report_object (v_report_id);
END IF;

v_stmt_no := 40;
-- show report on screen

web.show_document (
v_reports_server_url
|| 'getjobid'
|| SUBSTR (v_report, INSTR (v_report, '_', -1)
+ 1),
'_blank'
);

END proc_run_report;

Now, the problem is that there are no means thru which I can find out if the report does not exist. Because in such a case I want to display a message that "report does not exist".

Can you please help.

Thanks & Regards,

Monika Singhal
Previous Topic: bitmap and character reports
Next Topic: Oracle 9i Graph Legends Prob.
Goto Forum:
  


Current Time: Thu Mar 28 05:59:33 CDT 2024