Home » Developer & Programmer » Reports & Discoverer » calling report from another report (oracle reports,10g,Windows Xp)
calling report from another report [message #473697] Tue, 31 August 2010 04:18 Go to next message
sriranjani
Messages: 9
Registered: August 2010
Location: CHENNAI
Junior Member
I am new in oracle reports10g.I created two reports separately.

1.pub.jsp
2.serc.jsp


what i need is i want to call the report serc.jsp from pub.jsp.

How to do?Kindly send the steps


Thanks&Regards

sri
Re: calling report from another report [message #473698 is a reply to message #473697] Tue, 31 August 2010 04:23 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hyperlink.
Re: calling report from another report [message #473699 is a reply to message #473698] Tue, 31 August 2010 04:29 Go to previous messageGo to next message
sriranjani
Messages: 9
Registered: August 2010
Location: CHENNAI
Junior Member
How to create hyperlink?.I searched on net but i didnt get any solution.kindly send the steps to create the hyperlink


thanks & regards

sri
Re: calling report from another report [message #473700 is a reply to message #473699] Tue, 31 August 2010 04:31 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Please read below link.

http://www.orafaq.com/forum/m/467441/81953/#msg_467441

Regards,

Irfan
Re: calling report from another report [message #473835 is a reply to message #473700] Wed, 01 September 2010 01:22 Go to previous messageGo to next message
sriranjani
Messages: 9
Registered: August 2010
Location: CHENNAI
Junior Member
it doesn't work.herewith i attached pub.rdf report.

Kindly correct the report.I need urgently


regards

sri
  • Attachment: pub.rdf
    (Size: 56.00KB, Downloaded 148 times)
Re: calling report from another report [message #473842 is a reply to message #473699] Wed, 01 September 2010 01:46 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
sriranjani wrote on Tue, 31 August 2010 11:29
How to create hyperlink?.I searched on net but i didnt get any solution.

"oracle reports 10g drill down" is what you should be searching for. If you have access to Oracle Support, check
How To: Create Drill Down Web Reports Using Hyperlinks
Doc ID: Note:160262.1 

[Updated on: Wed, 01 September 2010 01:47]

Report message to a moderator

Re: calling report from another report [message #473853 is a reply to message #473835] Wed, 01 September 2010 03:38 Go to previous message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Mr.Sri,

Your report Query.

SELECT ALL PROJECT_PUBLICATIONS.PROJECT_NO, 
PROJECT_PUBLICATIONS.AUTHORS||','||
PROJECT_PUBLICATIONS.PUB_TITLE||','|| PROJECT_PUBLICATIONS.PUB_NAME||','|| PROJECT_PUBLICATIONS.VOLUME||','|| 

PROJECT_PUBLICATIONS.YEAR||','||PROJECT_PUBLICATIONS.PAGES


FROM PROJECT_PUBLICATIONS 
Group by project_no,AUTHORS,
PUB_TITLE,PUB_NAME,VOLUME,YEAR,PAGES



I checked your report I can't see any code written in the Layout columns Project_No,Project_publication_Authors_p Hyperlink property.

Please read above posts carefully & First try yourself.

Regards,

Irfan
Previous Topic: SQL & PL/SQL
Next Topic: Pick the Latest Record (Rank?) and Count
Goto Forum:
  


Current Time: Sat Nov 22 21:52:32 CST 2014

Total time taken to generate the page: 0.08304 seconds