OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » DRILL DOWN REPORTS (WINDOWS XP,ORACLE REPORTS 6i)

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

DRILL DOWN REPORTS [message #295734]

Wed, 23 January 2008 04:07

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

Report message to a moderator

Re: DRILL DOWN REPORTS [message #295953 is a reply to message #295734]

Thu, 24 January 2008 00:36

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.

Report message to a moderator

Re: DRILL DOWN REPORTS [message #349658 is a reply to message #295734]

Mon, 22 September 2008 09:48

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

Report message to a moderator

Previous Topic:	Reports doesnt show same values
Next Topic:	different dates single parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 18:07:46 CDT 2024