REP-300 Error while running report using App Server
429122Sep 24 2004 — edited Nov 4 2007Hi,
I am currently trying to run a report using the Application Server.
This report is being called from a form.
I am able to connect to the report server and all configurations seems to be correct.
But when I execute the report from the form, I am getting error "Unable to run report"
When I look at the error message in the Report Server queue, I find
"REP-300 Table or View does not exist.."
But that table does exist in the database.
What could be be the problem ?
Please help.
---------------------------------------------
The code in the form that calls the report is
report_id := FIND_REPORT_OBJECT( report_name );
vc_user_name:=get_application_property(username);
vc_user_password:=get_application_property(password);
vc_user_connect:=get_application_property(connect_string);
vc_connect:=vc_user_name||'/'||vc_user_password||'@'||vc_user_connect;
SET_REPORT_OBJECT_PROPERTY(report_id ,REPORT_OTHER, 'paramform=yes p_user_connect='||vc_connect ||' p_servername=repsrv'||' p_action=<host>/reports/rwservlet?' );
v_rep := RUN_REPORT_OBJECT(report_id, parmlist_id);
------------------------------------------------------