OraFAQ Forum: Reports & Discoverer » Drill down report in Oracle discoverer

Home » Developer & Programmer » Reports & Discoverer » Drill down report in Oracle discoverer (Oracle Discoverer Plus version 10.1.2.45.46c)

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

Drill down report in Oracle discoverer [message #428804]

Fri, 30 October 2009 02:41

k_mitra100
Messages: 28
Registered: October 2007
Location: Kolkata

Junior Member

Hi All,

I have a discoverer workbook in cross tab layout. It shows number of customers for each country and for different category like Distributors, Retailers etc.

Now I need to prepare a detail report in such a way so that the user will select a summary value for a country/category and the detail report for users of the said category and cuntry will be displayed.

A sample picture is added for your reference.

Can anyone help me in this regard?

Thanks in advance,
Kaushik

/forum/fa/6931/0/

Attachment: im1.JPG
(Size: 22.29KB, Downloaded 2794 times)

Report message to a moderator

Re: Drill down report in Oracle discoverer [message #429956 is a reply to message #428804]

Fri, 06 November 2009 08:39

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Create a different worksheet with the detail report and in the summary report add a link that connects it to the detailed worksheet and pass the parameters , so when you click on Japan in the summary report it will give you the details about Japan.Hope it helps

[EDITED by LF: removed unnecessary quote of the whole previous message]

[Updated on: Fri, 06 November 2009 09:24] by Moderator

Report message to a moderator

Re: Drill down report in Oracle discoverer [message #430136 is a reply to message #429956]

Mon, 09 November 2009 02:03

k_mitra100
Messages: 28
Registered: October 2007
Location: Kolkata

Junior Member

Hi Aarti,

Thanks for your help. It works for me.

Regards,

Report message to a moderator

Re: Drill down report in Oracle discoverer [message #456027 is a reply to message #430136]

Fri, 14 May 2010 02:55

k_mitra100
Messages: 28
Registered: October 2007
Location: Kolkata

Junior Member

Hi All,

Again I am facing an issue with drill down report.

I am modifying an existing report where a cross tab sheet is supposed to be linked to a detail sheet.

I am unable to activate the menu option tools-->manage link option here.

when I am selecting the item (from where drill down will start), I can see that the menu option (tools--->manage link) is always disabled.

Can anyone please help me in this regard?

Thanks,
Kaushik

Report message to a moderator

Previous Topic:	create table
Next Topic:	trigger procedure call

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 14:41:57 CST 2024