| Modify Run Report Msg [message #474059] |
Thu, 02 September 2010 07:49 |
meteo
Messages: 89
Registered: April 2010
Location: beirut
|
Member |
|
|
After I read some messages already posted discussing the run_report issue, I changed the old solution to a new one, through which I execute tho following steps:
1_ at run command prompt I excute the following one: rwserver - install server = rep_server
2_ I open the cgicmd.dat file and at the end if this file I added the following row:
rep_key: userid=meteo/meteo@dbrc[/email][/email] server=rep_ncragra-as %* %P
3_ i have developped a reprot
called "Res_R1_SaleOrdersPerCust.rdf" using report9i
builder and i compiled, saved it with an extention ".rdf " without error.
4_ i write a PLSQL trigger at button level called(INVOICEPUSH) through which i call the report as follow:
RUN_REPORT('RES_R1_SALEORDERSPERCUST', 'C');
This procedure has the fellowing code:
-- ---------------------------------------
PROCEDURE run_report(p_rpt_name varchar2, p_dest varchar2 default 'C')
IS
v_url varchar2(2000);
v_cur_form_name varchar2(100);
v_length number;
vPath_Sep char(1);
v_rpt_name_with_path varchar2(500);
v_rpt_format varchar2(50):='pdf'; -- Example: pdf,html,xml etc.
v_rpt_key varchar2(50):='Rep_key';
v_para_form varchar2(3) :='NO'; -- YES/NO
v_dest varchar2(20);
v_rpt_builder varchar2(200);
v_rpt_server varchar2(50);
BEGIN
--------Report_Path -------------
v_cur_form_name:=get_application_property(current_form);
if get_application_property(operating_system) in ('MSWINDOWS', 'MSWINDOWS32', 'WIN32COMMON') then
vPath_Sep := '\';
else
vPath_Sep := '/';
end if;
v_length:=instr(v_cur_form_name,vPath_Sep,-1);
--Getting Current Report Name With Path.
v_rpt_name_with_path:=substr(v_cur_form_name,1,v_length)||p_rpt_name;
------Report Destination-----
v_dest:=upper(p_dest);
if v_dest ='C' then
v_dest:='cache';
elsif v_dest='P' then
v_dest:='printer';
elsif v_dest='M' then
v_dest:='mail';
elsif v_dest='F' then
v_dest:='file';
end if;
-------Start Call Report----------
v_url:= '/reports/rwservlet?' ||v_rpt_key
||'&desformat=' ||v_rpt_format
||'&destype=' ||v_dest
||'¶mform=' ||v_para_Form
||'&report=' ||v_rpt_name_with_path;
web.show_document(v_url, '_blank');
--------End Call Report---------
exception
when others then null;
end;
-- --------------------------------------------
5_ in regedit I searched for:
REPORTS_PATH registry and add the following path: "D:\Dev9i\forms90\Meteo_Projet"
REPORTS_RESOURCE D registry and add the following path: "D:\Dev9i\forms90\Meteo_Projet"
6_ finally
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) in this message;
when i click at the button to load my report, my Internet Explorer is running with a blank page having url as follow:
http://wissam-bdd68698:8888/reports/rwservlet?Rep_key&desformat=pdf&destype=cache¶mform=NO&report=D:\Dev9i\forms9 0\Meteo_Projet\RES_R1_SALEORDERSPERCUST
still my report is not displayed!!!!! so idont know what went wrong with me!!! anything else I must do??? Or any of these steps is wrong or missing something?? please any other suggestions???
7_ hint :
- in this url Rep_key is not replces by it's value, aleardy assigned in cgicmd.dat by
rep_key: userid=meteo/meteo@dbrc[/email][/email] server=rep_ncragra-as %* %P
- My technical environment is Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i.
- my report 'RES_R1_SALEORDERSPERCUST'.rdf is saved in "D:\Dev9i\forms90\Meteo_Projet"
where I put all my live files(fmb, rdf,..)
-
Attachment: frmpic.JPG
(Size: 130.67KB, Downloaded 632 times)
[Updated on: Thu, 02 September 2010 08:19] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
