OraFAQ Forum: Reports & Discoverer » How to call a report from any existing report

Home » Developer & Programmer » Reports & Discoverer » How to call a report from any existing report (Reports 10g)

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

How to call a report from any existing report [message #298655]

Thu, 07 February 2008 00:33

minaxi_munjal
Messages: 5
Registered: September 2007
Location: India

Junior Member

Hi
I have created a report in 10g now i want to open any other report from this existing report? how to do it.

Please suggest
Thanx in advance

Meenakshi

Report message to a moderator

Re: How to call a report from any existing report [message #298658 is a reply to message #298655]

Thu, 07 February 2008 00:39

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

use srw.run report built-in procedure.

regards,

Report message to a moderator

Re: How to call a report from any existing report [message #298709 is a reply to message #298658]

Thu, 07 February 2008 04:28

minaxi_munjal
Messages: 5
Registered: September 2007
Location: India

Junior Member

Hi

I have used this package but it is not calling the report.

regards

Report message to a moderator

Re: How to call a report from any existing report [message #298716 is a reply to message #298709]

Thu, 07 February 2008 05:28

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does it do, then? How did you try to do that?

Report message to a moderator

Re: How to call a report from any existing report [message #298841 is a reply to message #298716]

Fri, 08 February 2008 00:13

minaxi_munjal
Messages: 5
Registered: September 2007
Location: India

Junior Member

I have used it in the following way :

SRW.RUN_REPORT('batch=yes report=empl destype=file desformat=dflt desname=empl.lis');

It is not calling empl report. It is very urgent for me
Please help

Report message to a moderator

Re: How to call a report from any existing report [message #298862 is a reply to message #298841]

Fri, 08 February 2008 01:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Where do you call it from? One of report triggers? Your own procedure? Something different?

Report message to a moderator

Re: How to call a report from any existing report [message #298885 is a reply to message #298862]

Fri, 08 February 2008 02:38

minaxi_munjal
Messages: 5
Registered: September 2007
Location: India

Junior Member

I have called it on Before Report Trigger. It gets compiled but not displaying report output.

Report message to a moderator

Re: How to call a report from any existing report [message #298931 is a reply to message #298655]

Fri, 08 February 2008 05:10

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

useful link --

http://www.oracle.com/webapps/online-help/reports/10.1.2/state/content/navId.3/navSetId._/vtTopicFile.htmlhelp_rwbuild_hs%7Crwrefex%7 Cplsql%7Cbuiltins%7Csrw%7Csrw_run_report~htm/

regards,

Report message to a moderator

Re: How to call a report from any existing report [message #299268 is a reply to message #298931]

Mon, 11 February 2008 01:39

minaxi_munjal
Messages: 5
Registered: September 2007
Location: India

Junior Member

I have already used the command from this link only but it is not working. I m really helpless.
Please help

Report message to a moderator

Re: How to call a report from any existing report [message #300102 is a reply to message #298655]

Thu, 14 February 2008 04:27

aurigian
Messages: 9
Registered: September 2005
Location: pakistan

Junior Member

there is no button object in 10gds u have to use web property
hyperlink field

e.g
u have 2 reports emp and dept and u calling emp report through dept report well in this scenarion u have to open dept report and set the above 2 parameter in deptno field

this address use in hyperlink property of dept field
http://webserver.domain:8888/reports/rwservlet?userid=demo/demo@ora9i+
report=dept_detail.rdf+destype=cache+desformat=html+P_deptno=&deptno

Note: In 9i you can use the testing oc4j webserver that comes with 9iDS for this
test: Start -> Programs -> Oracle9i Developer Suite - <instance name>
-> Report Developer -> Start OC4J Instance

Report message to a moderator

Re: How to call a report from any existing report [message #443487 is a reply to message #298931]

Tue, 16 February 2010 01:01

manudu20
Messages: 45
Registered: August 2008
Location: Mumbai

Member

Can you please tell me that how can we call a new report in new window in report10g.

Report message to a moderator

Re: How to call a report from any existing report [message #443661 is a reply to message #443487]

Tue, 16 February 2010 21:01

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Can you please tell me that how can we call a new report in new window in report10g

Open the report in a new window and run it.
If it not your requirement Be more specific.

sriram

Report message to a moderator

Re: How to call a report from any existing report [message #443672 is a reply to message #443661]

Tue, 16 February 2010 22:42

manudu20
Messages: 45
Registered: August 2008
Location: Mumbai

Member

I want to run a report from the existing report in a new window in report10g.

Report message to a moderator

Re: How to call a report from any existing report [message #443673 is a reply to message #300102]

Tue, 16 February 2010 22:45

manudu20
Messages: 45
Registered: August 2008
Location: Mumbai

Member

I am using the code you are using but the new report is running over the parent report, is their any way to open that report in new window.

Report message to a moderator

Previous Topic:	Calling a Report from Report in Report10g in new window
Next Topic:	Report can be viewed as Mirror

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 06:58:03 CST 2024