(unknown charset) Re: How to create a PDF report from the server

Embed the report into the form.
[Quoted] Use run_report_object to set up and run the report from the form.
Yes. you will need to be running forms and reports server on your server (obviously), in addition to the webserver be it 9iAS or apache.
In the launch form test for report completion. Here is a clue how to:

    rep_status:=REPORT_OBJECT_STATUS(report_job_id);

    WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
    LOOP
        rep_status := report_object_status(report_job_id);
    END LOOP;
 
    IF rep_status='FINISHED' THEN
      pvSuccess := TRUE;
      lvCompletion := 'Y';
    ELSE
      message ('Report failed with error message '||rep_status);
      pvSuccess := FALSE;
      lvCompletion := 'N';
    END IF;

Output the PDF file on the server to a directory where the web server can serve it up as a web page.

and then in the form use web_show_document to display the PDF. if your browser is configured correctly it will display native to the browser.

Be warned there is a bug in Reports6i whereby the PDF will sometimes not show entirely and complains about a 'format error' or something. The workaround is to set acrobat to remove the web browser integration in acrobat.
This may have been addressed in later releasese.  

zorro wrote:

> Hello,
>
> I'd like to create a some reports in PDF format with Oracle Report 6i. My
> reports must show up through Internet Explorer and the parameters must be
> passed through a Java Form built with Oracle Forms 6i.
>
> JInitiator ---> Form (Java) ----> Internet Explorer ---> Acrobat (Pdf)
>
> I would like to know what I need in the server side to run both the Java
> Form and the PDF report. Do I need Oracle 9i ? Do I need Report server ?
>
> Thank you for your help,
> Alan

--
Suzuki SV650S - plop.  Gone.
Kwak ZX-6R J2 - hear the roar