Home » Developer & Programmer » Reports & Discoverer » DRILL DOWN REPORTS (WINDOWS XP,ORACLE REPORTS 6i)
DRILL DOWN REPORTS [message #295734] Wed, 23 January 2008 04:07 Go to next message
dmerin
Messages: 30
Registered: December 2007
Member
Hi

I have created 2 reports mainly EMP_NEW.rdf and DEPT_NEWMAS.rdf
of which DEPT_NEWMAS.rdf is master and other child

with foll queries :
EMP_NEW.rdf
select * from emp WHERE DEPTNO=:p_deptno
DEPT_NEWMAS.rdf
select * from dept

My purpose is to create a drill down report
and created a button in DEPT_NEWMAS.rdf and gave foll code in pl/sql editor :

procedure CLICKButtonAction is
begin
srw.run_report('REPORT=C:\TEST\EMP_NEW.RDF batch=yes
P_DEPTNO ='||:DEPTNO);

end;

But its showing foll error
pls help

REP-1428: 'clickbutton action: Error while running srw.run_report

Please help
Re: DRILL DOWN REPORTS [message #295953 is a reply to message #295734] Thu, 24 January 2008 00:36 Go to previous messageGo to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

Hi,
Probably you are missing one more error before REP-1428 ('clickbutton action: Error while running srw.run_report).
That is "REP-0549: Destination type must be 'File', 'Printer', 'Mail', or 'Sysout' in batch mode.". My question is why you are specifying "bath=YES"? Instead of specifying batch you need to specify "DESTYPE=SCREEN". so your sample click code like ..
procedure clickButtonAction is
begin
  srw.run_report('REPORT=C:\My_wks\emp_new.rdf destype=screen P_DEPT_id ='||:department_id); 
end;


You need to change you report parameter, column names and rdf path etc.
Re: DRILL DOWN REPORTS [message #349658 is a reply to message #295734] Mon, 22 September 2008 09:48 Go to previous message
vareks
Messages: 1
Registered: September 2008
Junior Member
Hi,

Remove any spaces when specifying the paramter values and try again.

Eg:
srw.run_report('REPORT=C:\My_wks\emp_new.rdf destype=screen P_DEPT_id='||:department_id);

Hope it helps
Previous Topic: Reports doesnt show same values
Next Topic: different dates single parameter
Goto Forum:
  


Current Time: Sun Dec 04 20:52:03 CST 2016

Total time taken to generate the page: 0.15866 seconds