tolong check syntax berikut ya?
declare
v_report_id Report_Object;
vc_report_job_id VARCHAR2(100); /* unique id for each Report request */
vc_rep_status VARCHAR2(100); /* status of the Report job */
BEGIN
v_report_id:= FIND_REPORT_OBJECT('REP1001');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,
:INIT.REPFORMAT);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,'Rep60_PRODIN');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'ASSET_ID='||:INIT.asset_id||'TAHUN='||:INIT.tahun||'BULAN='||'P_MKEU='||:INIT.manajer_keuangan||'P_SPS='||:INIT.sps_akutansi||'P_KOTA='||:INIT.kota||'paramform=no');
vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job_id);
IF vc_rep_status='FINISHED' THEN
Web.show_document
('http://prodin/dev60cgi/rwcgi60.exe/getjobid='||vc_report_job_id||'?server=Rep60_PRODIN','_blank');
ELSE
message ('Report failed with error message '||vc_rep_status);
END IF;
END;
sebenarnya pake web.show sudah bisa, cuma masalah terjadi userid
tampil di browser.
terima kasih