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

Hi Ana,

I did set the EXECUTION_MODE property to BATCH before I call the report (look the code below). It's not helping .. I heard it's setting in the form (assuming all properties are set properly when the report is called).

Thanks anyways,
a.

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:OaaCa.61348$MJ5.13592_at_fed1read03...
> 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 - 19:07:08 CDT