| Runig Report within form [message #475854] |
Sat, 18 September 2010 04:24 |
meteo
Messages: 89
Registered: April 2010
Location: beirut
|
Member |
|
|
Hi i will be very grateful if anyone can help me!!
I read carefully all of the topics related to runnig a report from within a form; It's very clear what it has been sent, I understand it very well and I followed all of the instructions step by step, so I will gave you a summary on what I have made until now:
1- in REPORTS_PATH registry i add the following path: "D:\Dev9i\forms90\Meteo_Projet" -- where I put all my live files(fmb, rdf,..)
2- i have developped a reprot called "Res_R1_SaleOrdersPerCust.rdf" using report9i builder and i campiled saved it without error.
3- At DOS command prompt I create "repserver90" by exection the following commad : "rwserver -install repserver90" and then
I started it by clicking at control pannel -----adminstartive tools---- services ; and it goes well
4- 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
5- i write a PLSQL trigger at button level called(INVOICEPUSH) through which i call the report as follow:
Declare
repid REPORT_OBJECT;
v_rep varchar2(100);
rep_status varchar2(50);
Begin
repid := find_report_object('Res_R1_SaleOrdersPerCust');
-- Set Report Object properties
-------------------------------
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, CACHE);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'HTML');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, 1);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_SERVER, :block1.SERVERNAME);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_FILENAME, :block1.REPNAME);
SYNCHRONIZE;
-- Run report and get status
-------------------------------
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := report_object_status(v_rep);
SYNCHRONIZE;
-- Wait for Reports to generate results
-- The loop is only needed if COMM_MODE=2 (ASYNCHRONOUS)
----------------------------------------
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
SYNCHRONIZE;
-- If DESTYPE is appropriate for displaying to user, execute WEB.SHOW
IF rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||:block1.SERVERNAME,'_blank');
ELSE
-- Something went wrong
message(rep_status);
END IF;
END;
Finally:
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/getjobid49?server=repserver90
still my problem is not solved...my report is not displayed...really I ma very confused
So
i believe still a configuration issue I must apply but I don't now what it is ; either : cgicmd, formsweb, rwservlet files or other files; so Mr any configuration is missing in any of these files or another file??? If yes, can you give me the details of any configuration required to apply it in the associated file.
any thing is missing or not true in the executed steps mentioned above???
Really I m very grateful for your help.
hint
My technical environment is: Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i
my form is attached as a picture in this topics
-
Attachment: formpic.JPG
(Size: 117.91KB, Downloaded 616 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
