Re: Can't run report in ASYNCHRONOUS mode - forms/reports 9i

Hi Arturo,

I spent two days this week trying to solve an identical problem and have come up with a workaround. The Communication Mode property, to the best of my knowledge, does absolutely nothing in Forms9i. In order to call a report and have control returned to the form, I had to use the reports server parameter SCHEDULE=NOW passed as a parameter list to RUN_REPORT_OBJECT. The code is as follows:  

declare
  repid report_object;
  v_rep varchar2(8);
  pl_id paramlist;
begin
  pl_id := create_parameter_list('tmpdata');   add_parameter(pl_id,'SCHEDULE',text_parameter,'NOW');   repid := find_report_object('m_cnt_mbr_mt');   v_rep := run_report_object(repid,pl_id); end;

Good luck!

Brian

"Arturo" <aparafiniuk_at_rogers.com> wrote in message news:<H49Ca.315701$w7k.141794_at_news04.bloor.is.net.cable.rogers.com>...
> Hi All,
>
> I'm trying to make a report run in ASYNCHRONOUS mode. I want to press a
> button on a form, submit the report to the reports server and be able to
> navigate within the form while the report is being executed on the reports
> server.
>
> My problem is, no matter what mode I choose (ASYNCHRONOUS or SYNCHRONOUS),
> the mode ALWAYS ends up being SYNCHRONOUS. After I press the button (code
> below), I get the hourglass and I can't navigate within the form until the
> report is finished. Then I can view it.
>
> The reports server I'm using is installed locally on the same PC I'm testing
> the form.
>
> Can someone help me please? I'm using using Forms Builder 9.0.2.9.0 - I was
> told the communication mode is something that forms handles when calling
> run_report_object.
>
> Thank you,
> Artur
>
>
> declare
>
> v_repid REPORT_OBJECT;
> v_rep in varchar2(100);
>
> begin
> v_repid := find_report_object('TEST');
>
> SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_EXECUTION_MODE, BATCH);
>
> SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_COMM_MODE, ASYNCHRONOUS);
>
> SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESTYPE, 'CACHE');
>
> SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESFORMAT, 'PDF'); -- OR HTMLCSS
>
> SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_SERVER, 'REPSERV'); -- local pc
> reports server
>
> v_rep := RUN_REPORT_OBJECT(v_repid);
>
> end;
Received on Thu Jun 05 2003 - 22:26:38 CEST