| Re Modify run report [message #474523] |
Mon, 06 September 2010 17:31 |
meteo
Messages: 89
Registered: April 2010
Location: beirut
|
Member |
|
|
After I read in details a new document details how to call a report fron a form, I modified my solution to a new one, through which I execute tho following steps:
1_ at run command prompt I excute the following one: rwserver - install repserver90 --and it's ok
2_ at controlpannel - serivces- I start repserver 90 --and it's ok
3_ I open the cgicmd.dat file and at the end if this file I added the following row:
G7_F3_REP_CUSTINV: userid=meteo/meteo@dbrc server=repserver90 destype=cache
4_ i have developped a reprot called "Res_R1_SaleOrdersPerCust.rdf" using report9i builder and i compiled, saved it with an extention ".rdf " without error.
5_ i write a PLSQL trigger at button level called(INVOICEPUSH) through which i call the report as follow:
RUN_REPORT_OBJECT_PROC ('Res_R1_SaleOrdersPerCust', 'repserver90', 'pdf') ;
This procedure has the fellowing 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*/
-- vc_url VARCHAR2(100);
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/getjobid'|| vjob_id||'?server=' || vc_reportserver ,'_blank');
ELSE
message ('Report failed with error message '||vc_rep_status);
END IF;
END;
6-Finally when I treid to run this report within form9i form builder through which i create a form called (G7_F3_REP_CUSTINV.fmb);
when i click at the button to load my report, a message is shown : FRM-41213: Unable to connect to the Report Server repserver90
So 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 to override the error diplayed by this message???
hint:
My technical environment is Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
