Home » Developer & Programmer » Reports & Discoverer » Drill down report in Oracle discoverer (Oracle Discoverer Plus version 10.1.2.45.46c)
Drill down report in Oracle discoverer [message #428804] Fri, 30 October 2009 02:41 Go to next message
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

./fa/6931/0/
  • Attachment: im1.JPG
    (Size: 22.29KB, Downloaded 1146 times)
Re: Drill down report in Oracle discoverer [message #429956 is a reply to message #428804] Fri, 06 November 2009 08:39 Go to previous messageGo to next message
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 Go to previous messageGo to next message
k_mitra100
Messages: 28
Registered: October 2007
Location: Kolkata
Junior Member
Hi Aarti,

Thanks for your help. It works for me.


Regards,
Re: Drill down report in Oracle discoverer [message #456027 is a reply to message #430136] Fri, 14 May 2010 02:55 Go to previous message
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
Previous Topic: create table
Next Topic: trigger procedure call
Goto Forum:
  


Current Time: Sun Sep 25 21:22:59 CDT 2016

Total time taken to generate the page: 0.15342 seconds