Home » Developer & Programmer » Reports & Discoverer » problem with report parameter
problem with report parameter [message #545412] Wed, 29 February 2012 03:47
windowsdos
Messages: 29
Registered: May 2011
Junior Member
declare
v_report_id report_object;
v_rep varchar2(100);
rep_status varchar2(100);
list1 paramlist;

begin
v_report_id := find_report_object('myreport');
set_report_object_property(v_report_id,report_server,'RptSvr_fusion_asinst_1');
set_report_object_property(v_report_id,report_execution_mode,RUNTIME);
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,'htmlcss');
set_report_object_property(v_report_id, report_other, 'paramform=yes');

v_rep := run_report_object(v_report_id);
rep_status := report_object_status(v_rep);

while rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
rep_status := report_object_status(v_rep);
end loop;

if rep_status = 'FINISHED' then
destroy_parameter_list(list1);
web.show_document('http://localhost:9002/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=RptSvr_fusion_asinst_1','_blank');
else
message('Error');
end if;

end;

-----------------------------------


when i write the above code in the button at my form
and when i press on this button the report run with parameter
but whrn i enter the report parameter value the next error appear
what can i do to solve this problem????


Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.



Previous Topic: Unable to Connect to DB from Reports10g
Next Topic: SUMMARY COLUMN HAVE TOBE USED IN THE FORMAT TRIGGER
Goto Forum:
  


Current Time: Thu Mar 28 16:06:15 CDT 2024