| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
