OraFAQ Forum: Reports & Discoverer » calling report from another report

Home » Developer & Programmer » Reports & Discoverer » calling report from another report (oracle reports,10g,Windows Xp)

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

calling report from another report [message #473697]

Tue, 31 August 2010 04:18

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

Report message to a moderator

Re: calling report from another report [message #473698 is a reply to message #473697]

Tue, 31 August 2010 04:23

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

Senior Member
Account Moderator

Hyperlink.

Report message to a moderator

Re: calling report from another report [message #473699 is a reply to message #473698]

Tue, 31 August 2010 04:29

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

Report message to a moderator

Re: calling report from another report [message #473700 is a reply to message #473699]

Tue, 31 August 2010 04:31

ranamirfan
Messages: 535
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

Report message to a moderator

Re: calling report from another report [message #473835 is a reply to message #473700]

Wed, 01 September 2010 01:22

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 1358 times)

Report message to a moderator

Re: calling report from another report [message #473842 is a reply to message #473699]

Wed, 01 September 2010 01:46

Littlefoot
Messages: 21808
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

ranamirfan
Messages: 535
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:36:04 CDT 2024