Rekan Oracle
Pada saat saya menjalankan perintah dibawah untuk menjalankan Report
dengan Passing parameter muncul Error
" REP-50004: No report specified on the command line ", Dari teman2
mungkin ada yang bisa membantu memberikan solusi,
mohon pencerahannya
nb: saya memakai FormDS 10G untuk mejalankan Report10g
Terimakasih
Dit
-------------------------------------------------------------------------------------------------------------------
declare
param_list paramlist;
report_id REPORT_OBJECT;
ReportServerJob VARCHAR2(100);
v_jobID VARCHAR2(100);
rep_status VARCHAR2(20);
reportserver VARCHAR2(30);
v_url VARCHAR2(200);
begin
IF NOT Id_Null(param_list) then
Destroy_Parameter_List(param_list);
END IF;
param_list := Create_Parameter_List ('tmp');
report_id := find_report_object('rpt_name');
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_EXECUTION_MODE, BATCH);
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_DESTYPE, cache);
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_DESFORMAT, 'html');
SET_REPORT_OBJECT_PROPERTY(Report_Id, REPORT_FILENAME,
'C:\test\test_penmaru.rdf');
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_SERVER, 'rep_ditya');
Add_Parameter(param_list,'paramform',TEXT_PARAMETER,'no');
Add_Parameter(param_list,'p_notest',TEXT_PARAMETER, :nim);
Add_Parameter(param_list,'PRINTJOB',TEXT_PARAMETER,'NO');
ReportServerJob := run_report_object(report_id, param_list);
v_jobID :=
substr(ReportServerJob,length('rep_ditya')+2,length(ReportServerJob));
rep_status := report_object_status(ReportServerJob);
WHILE rep_status in ('RUNNING', 'OPENING_REPORT','ENQUEUED') LOOP
rep_status := report_object_status(ReportServerJob);
END LOOP;
IF rep_status = 'FINISHED' THEN
v_url :=
'http://ditya:8889/reports/rwservlet?getjobid='||v_jobID||'?server=rep_ditya';
Web.Show_Document(v_url,'_blank');
END IF;
-- Destroy_Parameter_List(param_list);
end;
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
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/
