Re: Running web Report from web Form

From: Miran Kopmajer <miran.kopmajer_at_eurosplet.si>
Date: 18 Mar 2004 01:13:58 -0800
Message-ID: <45a19c11.0403180113.7d9b5ecd@posting.google.com>

> I'm just the messenger, so don't shoot me.
>
> RUN_REPORT_OBJECT does not work with a Reports Server which has an
> underscore character ("_") as part of its name. You need to create
> a Reports Server named something other than "rep_server".

I tried little more...
I renamed my server name to "repserver" wihtout underscore character ("_") and invoked 2 different reports ('DOBAVITELJI' AND 'DOBAVITELJI1') to object navigator and still get message "Unable to run report". With "Message(v_rep);" I tried to find out what "v_rep" ACTUALLY is and in both cases I got message "repserver_0". Is 0 ID of report or what? Is that value indicating that report cannot be found?

Any ideas?

Below is my new KEY-PRINT trigger

DECLARE

	repid report_object;
	v_rep varchar2(100);

BEGIN
  repid := find_report_object('DOBAVITELJI1');

  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,RUNTIME); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,PREVIEW); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'html'); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'repserver'); 
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no' ); 

  v_rep := RUN_REPORT_OBJECT(repid);

  Message(v_rep);

END; THX,miran Received on Thu Mar 18 2004 - 03:13:58 CST