| Runing_Report_Within_Form [message #475018] |
Fri, 10 September 2010 16:11 |
meteo
Messages: 89
Registered: April 2010
Location: beirut
|
Member |
|
|
hi anyone can help me????
I read every topics posted in this subject and I execute it step by step; I re_modified my solution to a new one, through which I execute tho following steps:
- started repserver90 already created by clicking at control pannel -----adminstartive tools---- services ; and it goes well
- in the file cgicmd.dat i added the follwoing row: G7_F3_REP_CUSTINV: userid=meteo/meteo@dbrc[/email] server=repserver90 destype=cache is this true anything else is missing????
- REPORTS_PATH registry and add the following path: "D:\Dev9i\forms90\Meteo_Projet"
now 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?server=repserver90&report=Res_R1_SaleOrdersPerCust.rdf&desformat=pdf&destyp e=cache&userid=meteo/meteo@dbrc¶mform=no
still my report is not displayed!! even if u see this URL: hostname, port, sever name, rdf file name, .... everything goes well
my procedure has the following code:
PROCEDURE RUN_REPORT_OBJECT_PROC (vc_reportoj Varchar2, vc_reportserver varchar2, vc_runformat varchar2)
IS
v_report_id Report_Object;
vc_ReportServerJob VARCHAR2(100); /* unique id for each Report request*/
vc_rep_status VARCHAR2(100); /* status of the Report job */
vjob_id VARCHAR2(100); /* job_id as number only string*/
BEGIN
/* Get a handle to the Report Object itself. */
v_report_id := FIND_REPORT_OBJECT(vc_reportoj);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
/* Define the report output format and the name of the Reports Server
as well as a user-defined parameter,There's no need for a parameter form to be displayed,so paramform is set to "no". */
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT, vc_runformat);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,vc_reportserver);
vc_ReportServerJob:=RUN_REPORT_OBJECT(v_report_id);
vjob_id := substr(vc_ReportServerJob,length(vc_reportserver)+2,length(vc_ReportServerJob));
/* If finished, check the report status . */
vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);
IF vc_rep_status= 'FINISHED'
THEN
WEB.SHOW_DOCUMENT ('/reports/rwservlet?server=' || vc_reportserver
||'&report=Res_R1_SaleOrdersPerCust.rdf&desformat=pdf'
||'&destype=cache&userid=meteo/meteo@dbrc¶mform=no'
,'_blank');
ELSE
message ('Report failed with error message '||vc_rep_status);
END IF;
END;
-- ============================================================
notes:
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,..)
[Updated on: Fri, 10 September 2010 16:16] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
