OraFAQ Forum: Reports & Discoverer » Solution for the error REP-52007

Home » Developer & Programmer » Reports & Discoverer » Solution for the error REP-52007 (oracle IDS 10g, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Solution for the error REP-52007 [message #380124]

Fri, 09 January 2009 03:56

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Hi All!

I have created a parameter report which i called through a push button from a form ..

Now the report gets opened initially when i enter a value and submit, it gives me the error

   REP-52007: Parameter form format error.

I used the coding

Declare
repid REPORT_OBJECT;
v_rep VARCHAR2(1000);
rep_status VARCHAR2(20);
--PF_1 paramlist;
BEGIN
repid := find_report_object('REPORT120');


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_SERVER,' rserver');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'HTMLCSS');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'PF_1','paramform=yes');
  
v_rep := RUN_REPORT_OBJECT(repid);
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://serc:8889/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rserver','_blank');
 
ELSE
 
message('Error when running report');
END IF; 
END;

Please help me to overcome this error !

Thanks and Regards,
Varosh

Report message to a moderator

Re: Solution for the error REP-52007 [message #380136 is a reply to message #380124]

Fri, 09 January 2009 04:31

Littlefoot
Messages: 21808
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.

Report message to a moderator