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

Arturo wrote:
> 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;
>
>

With free advice you get what you paid for it. AFAIK for 9iAS R2 setting parameter BATCH=YES, just might get you what you want.
Then again, maybe not.
This is like giving chicken soup to a dead man, it can't hurt & just might help.

HTH & YMMV HAND! Received on Sat May 31 2003 - 17:39:41 CDT