| Runing Report [message #473029] |
Wed, 25 August 2010 08:42 |
meteo
Messages: 89
Registered: April 2010
Location: beirut
|
Member |
|
|
My technical environment is
Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i.
i have developped a reprot called "Res_R1_SaleOrdersPerCust.rdf" using report9i builder and i campiled saved it without error.
now i try to run this report within form9i form builder through which i create a form called (G7_F3_REP_CUSTINV.fmb) this form is attached as picture(frmpic.jpg),
i write a PLSQL trigger at button level called(INVOICEPUSH) through which i call the report as follow:
declare
repoutputname varchar2(1000);
v_rep varchar2(1000);
the_param varchar2(1500) := 'tmpdata';
pl_id paramlist;
repid REPORT_OBJECT;
begin
repid := find_report_object('RES_R1_SALEORDERSPERCUST');
repoutputname := 'D:\Dev9i\forms90\Meteo_Projet\'; -- where i pull all my live file such fmb rdf...
pl_id := get_parameter_list(the_param);
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id := create_parameter_list(the_param);
add_parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
add_parameter(pl_id, 'DESFORMAT', TEXT_PARAMETER, 'RDF');
add_parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'FILE');
add_parameter(pl_id, 'DESNAME', TEXT_PARAMETER, repoutputname);
v_rep := RUN_REPORT_OBJECT(repid, pl_id);
end;
I specified the reports path in REPORTS_PATH in the registry as follow: "D:\Dev9i\forms90\Meteo_Projet"
finally when i run my form and i click at the bottom "INVOICEPUSH" my report is not loaded!!!
any thing else i must do??? any thing missing in my PLSQL trigger??? thank you.
-
Attachment: frmpic.JPG
(Size: 130.67KB, Downloaded 610 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
