Home » Developer & Programmer » Forms » REP-52007: Parameter form format error
REP-52007: Parameter form format error [message #456347] Mon, 17 May 2010 06:49 Go to next message
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 #456356 is a reply to message #456347] Mon, 17 May 2010 07:21 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle

REP-52007: Parameter form format error.

Cause:   The submitted parameter form has an invalid format.

Action:   Please check if the 'hidden_run_parameters' variable in the parameter form is null.

[Updated on: Mon, 17 May 2010 07:23]

Report message to a moderator

Re: REP-52007: Parameter form format error [message #456362 is a reply to message #456356] Mon, 17 May 2010 07:44 Go to previous messageGo to next message
mahajneh
Messages: 16
Registered: May 2010
Junior Member
what did you mean by 'hidden_run_parameters' ??
please more detailed solutions.
Re: REP-52007: Parameter form format error [message #456643 is a reply to message #456347] Wed, 19 May 2010 01:42 Go to previous messageGo to next message
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
Re: REP-52007: Parameter form format error [message #456646 is a reply to message #456643] Wed, 19 May 2010 01:50 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks for the feedback.
It would be helpful for others if you post that URL here
sriram Smile
Re: REP-52007: Parameter form format error [message #456953 is a reply to message #456646] Thu, 20 May 2010 07:42 Go to previous message
mahajneh
Messages: 16
Registered: May 2010
Junior Member
you can find it at http://www.oracle.com/technology/products/forms/pdf/10g/frmwebshowdoc_rep.pdf

or you can google it.
Previous Topic: Refresh datablock after DML operation(s)
Next Topic: secure web.show_document()
Goto Forum:
  


Current Time: Fri Sep 20 09:51:19 CDT 2024