Run report from form

[Giordano Torelli]

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

[Newsgroups]

"Giordano Torelli" <giordanotorelli@yahoo.it.invalid> wrote in
news:btuhs8$n4t$1@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.

[Giordano Torelli]

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@TheMattesFamily.ws> ha scritto nel messaggio
news:Xns946E7BACC61B8ScottatTheMattesFami@24.48.107.54... "Giordano Torelli" <giordanotorelli@yahoo.it.invalid> wrote in news:btuhs8$n4t$1@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.