Home » Developer & Programmer » Reports & Discoverer » How to call a report from any existing report (Reports 10g)
How to call a report from any existing report [message #298655] Thu, 07 February 2008 00:33 Go to next message
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
Re: How to call a report from any existing report [message #298658 is a reply to message #298655] Thu, 07 February 2008 00:39 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
use srw.run report built-in procedure.

regards,
Re: How to call a report from any existing report [message #298709 is a reply to message #298658] Thu, 07 February 2008 04:28 Go to previous messageGo to next message
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
Re: How to call a report from any existing report [message #298716 is a reply to message #298709] Thu, 07 February 2008 05:28 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does it do, then? How did you try to do that?
Re: How to call a report from any existing report [message #298841 is a reply to message #298716] Fri, 08 February 2008 00:13 Go to previous messageGo to next message
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
Re: How to call a report from any existing report [message #298862 is a reply to message #298841] Fri, 08 February 2008 01:11 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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?
Re: How to call a report from any existing report [message #298885 is a reply to message #298862] Fri, 08 February 2008 02:38 Go to previous messageGo to next message
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.
Re: How to call a report from any existing report [message #298931 is a reply to message #298655] Fri, 08 February 2008 05:10 Go to previous messageGo to next message
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,
Re: How to call a report from any existing report [message #299268 is a reply to message #298931] Mon, 11 February 2008 01:39 Go to previous messageGo to next message
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
Re: How to call a report from any existing report [message #300102 is a reply to message #298655] Thu, 14 February 2008 04:27 Go to previous messageGo to next message
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
Re: How to call a report from any existing report [message #443487 is a reply to message #298931] Tue, 16 February 2010 01:01 Go to previous messageGo to next message
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.
Re: How to call a report from any existing report [message #443661 is a reply to message #443487] Tue, 16 February 2010 21:01 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: How to call a report from any existing report [message #443672 is a reply to message #443661] Tue, 16 February 2010 22:42 Go to previous messageGo to next message
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.
Re: How to call a report from any existing report [message #443673 is a reply to message #300102] Tue, 16 February 2010 22:45 Go to previous message
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.
Previous Topic: Calling a Report from Report in Report10g in new window
Next Topic: Report can be viewed as Mirror
Goto Forum:
  


Current Time: Thu Sep 29 09:01:58 CDT 2016

Total time taken to generate the page: 0.16269 seconds