Re: Run report from form

From: Giordano Torelli <giordanotorelli_at_yahoo.it.invalid>
Date: Tue, 13 Jan 2004 11:39:58 +0100
Message-ID: <bu0hab$g14$1_at_grillo.cs.interbusiness.it>


Hi,

Thanks Scott, but I'had already inserted the report in the Object Navigator: it didn't work because I'm simply referred to it using the name of the file (my_report.RDF) and not his name in the Navigator.

Now I have another problem: running the report, it's created two file ('my_report.LIS', 'reports.txt') and an application, 'Management module of the reports in background', is launched and it says me only the times of the begin and end of the 'my_report' (the difference between them amount at one second about).
But I can't see nothing!
How I can see my report?
And how can I display it in particular format, for example PDF?

Thanks a lot, best regards
Giordano

"Scott Mattes" <Scott_at_TheMattesFamily.ws> ha scritto nel messaggio news:Xns946E7BACC61B8ScottatTheMattesFami_at_24.48.107.54...
> "Giordano Torelli" <giordanotorelli_at_yahoo.it.invalid> wrote in
> news:btuhs8$n4t$1_at_grillo.cs.interbusiness.it:
>
> > Hello to everybody!
> >
> > I need to run a report from a form, developed with Oracle Forms
> Builder.
> > To do this I have created a button with a trigger on the event
> > WHEN-BUTTON-PRESSED, with the following PL/SQL code:
> >
> > DECLARE
> > repid REPORT_OBJECT;
> > v_rep VARCHAR2(100);
> > rep_status varchar2(20);
> > BEGIN
> > :GLOBAL.PROJECT_PATH:='c:\my_work_path\';
> > repid := find_report_object('ru.RDF');
> > v_rep := RUN_REPORT_OBJECT(repid);
> > END;
> >
> > Forms Builder compile this, but when I run my form and I click on the
> > button, the following error message is displayed:
> >
> > FRM-41219: Impossible to find the report: ID not valid.
> >
> > Can you help me to solve this problem?
> > Thanks, regards,
> >
> > Giordano
>
> In the help for RUN_REPORT_OBJECT it says
>
> ============
> Syntax
>
> FUNCTION RUN_REPORT_OBJECT
> (report_id REPORT_OBJECT
> );
>
> Built-in Type unrestricted procedure
> Returns VARCHAR2
> Enter Query Mode yes
>
> Parameters
>
> report_id Specifies the unique ID of the report to be run. You can get
> the report ID for a particular report using the built-in
> FIND_REPORT_OBJECT.
>
> Usage Notes
>
> n Returns a VARCHAR2 value that uniquely identifies the report that is
> running either locally or on a remote report server. You can use this
> report ID string as a parameter to REPORT_OBJECT_STATUS ,
> COPY_REPORT_OBJECT , and CANCEL_REPORT_OBJECT.
>
> =============
>
> I think that you have to Add a Report in the Object Navigator first,
> then you can reference that.
Received on Tue Jan 13 2004 - 11:39:58 CET

Original text of this message