| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
