REP-52007: Parameter form format error [message #456347] |
Mon, 17 May 2010 06:49 |
mahajneh
Messages: 16 Registered: May 2010
|
Junior Member |
|
|
hello everybody
I have a problem to run my reports with parameter form , if I set paramform=yes then I have the error (REP-52007: Parameter form format error)
but when i run them without the parameter form then it works well
i use this code to call my report::::
LIST_ID := GET_PARAMETER_LIST('TMPDATA');
IF NOT ID_NULL(LIST_ID) THEN
DESTROY_PARAMETER_LIST(LIST_ID);
END IF;
LIST_ID := CREATE_PARAMETER_LIST('input_param');
ADD_PARAMETER(LIST_ID, 'FBRANCH', TEXT_PARAMETER, TO_CHAR(:BLK1.HEC_BRANCH));
ADD_PARAMETER(LIST_ID, 'TBRANCH', TEXT_PARAMETER, TO_CHAR(:BLK1.HEC_BRANCH));
ADD_PARAMETER(LIST_ID, 'FOFFICE', TEXT_PARAMETER, TO_CHAR(:BLK1.HEC_OFFICE));
ADD_PARAMETER(LIST_ID, 'TOFFICE', TEXT_PARAMETER, TO_CHAR(:BLK1.HEC_OFFICE));
ADD_PARAMETER(LIST_ID, 'FCLM_NO', TEXT_PARAMETER, TO_CHAR(:BLK1.HEC_CLM_NO));
ADD_PARAMETER(LIST_ID, 'TCLM_NO', TEXT_PARAMETER, TO_CHAR(:BLK1.HEC_CLM_NO));
ADD_PARAMETER(LIST_ID, 'paramform', TEXT_PARAMETER, ('yes'));
repid := find_report_object('Acrep30A');
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,'pdf');
set_report_object_property(repid,report_server,'repserver10');
v_rep := RUN_REPORT_OBJECT(repid,LIST_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
WEB.SHOW_DOCUMENT
('http://app_server:8889/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repserver10','_blank');
ELSE
message('Error when running report');
END IF;
synchronize;
destroy_parameter_list(list_id);
END;
any help please
any declaration will be posted on demand
CM: replaced [b] and [colour] tags with [code] tags. In future use code tags for code.
[Updated on: Mon, 17 May 2010 07:00] by Moderator Report message to a moderator
|
|
|
|
|
Re: REP-52007: Parameter form format error [message #456643 is a reply to message #456347] |
Wed, 19 May 2010 01:42 |
mahajneh
Messages: 16 Registered: May 2010
|
Junior Member |
|
|
hello everybody
i solved this problem,
The reason for Reports parameter forms not working, when called from Forms using the RUN_ REPORT_OBJECT Built-in, is an empty action attribute in the generated Reports HTML parameter form. Because RUN_REPORT_OBJECT()calls Reports directly on the server, Reports cannot access the Web environment to obtain the information required to populate the action attribute when generating the HTML parameter form.
The <ACTION> attribute is part of the standard HTML <FORM> tag that defines what to do when a user presses the submit button. The <ACTION> attribute in the Reports parameter form should contain hidden runtime parameters that are required to process the Reports request after the user presses the submit button.
the solution of this problem is founed at the paper
<<Oracle Forms Services Using run_report_object to run reports with parameter form>>
I hope this will be helpful
|
|
|
|
|