ada yg tahu cara konvert report ke excell?
applikasi yg berjalan sekarang web base menggunakan web service
Oracle application server 10 g
saya udah coba menambahkan/mendeklarasikan vnd.excell di mime.type
sementara untuk report type lainya lancar seperti report untuk format
pdf tidak ada masalah
declare
repid report_object;
vrep varchar2(100);
rep_status varchar2(100);
v_jobID varchar2(100);
begin
repid := find_report_object('REPORT19');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,RUNTIME);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'DELIMITED');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_pool-11189');
SET_REPORT_OBJECT_PROPERTY
(repid,REPORT_OTHER,'mimetype=application/x-msexcel');
vrep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(vrep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
rep_status := report_object_status(vrep);
END LOOP;
--yang ini alternati pertama
v_jobID := substr(vrep,length(:global.rep_server)
+2,length(vrep));
web.show_document('http://pool-
11189.id.sampoerna.com:7777/reports/rwservlet/getjobid'||
v_jobID||'?server=rep_pool-
11189&mimetype=application/x-msexcel','_blank');
--Web.show_document
('http://<webhost>:port/dev60cgi/rwcgi60.exe/getjobid='||substr
(vrep,8)||'?server=repserv&mimetype=application/x-msexcel','_blank');
end;
yang ini alternatif kedua
IF rep_status = 'FINISHED' THEN
--web.show_document('http://training-
1.id.sampoerna.com:8889/reports/rwservlet/getjobid'||
-- v_jobID||'?server='||'rep_training-1');
v_url:='http://pool-
11189.id.sampoerna.com:7777/reports/rwservlet/getjobid'||
v_jobID||'?server='||:global.rep_server;
v_url:=encode_url(v_url);
web.show_document('http://pool-
11189:7777/rep/rep2excel.exe?
filepath='||v_url||'&job=preview','_blank');
else
message('Report : ' || rep_status);
end if;
else
msg('Error When Running Report');
end if;
semuanya tidak jalan saat konvert ke excell
ada yg bisa bantu
terimakasih pencerahanya
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
