Members   Search   Help    Register    Login   Home
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: 17
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 89 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 Go to previous messageGo to next message
aarti81
Messages: 210
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 message
k_mitra100
Messages: 17
Registered: October 2007
Location: Kolkata
Junior Member
Hi Aarti,

Thanks for your help. It works for me.


Regards,
Report message to a moderator
Previous Topic:Dont wants to show certain matrix columns
Next Topic:Exporting Db tables to file and Import from Report Builder
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 17:36:00 CST 2009

Total time taken to generate the page: 0.02962 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.