Create a Report with Drill-through Access to Itself

[latifpatel]

Hi,
Can any one help me please??

My issue as :
I have one list & chart  both in one report.
Want drill through from list to chart in same report.
Ex : If click on order no ABC from list then it should show all order detail of ABC in Chart.And the above list report should not be change.

I got succeed in the drill through but list is changing according to the drill.
Thanks in advance.

[wyconian]

Hi

Sounds like you need to have separate queries for the list and the chart so you can pass the parameter from the list to the chart.

Good luck :-)

[latifpatel]

Thanks for reply.
I have already create two query .
One for list  & second for chart.



Thanks

[Satheesh]

Hi,


Create 2 Queries One is for List and One is For Chart.
after that in Chart Use Filter based on which your chart data has to filter.


Create one Boolean Variable with parameter is null


Create a list report with drill thru...


drag 2 conditional blocks....
Assign Boolean variable 'yes' for one Condition block and as well as 'no' for another conditional block


copy the list report and paste the same in 2 conditional blocks...


Run the report....




But It will ask you default prompt page first...
Bcoz of Self Drill




Sateesh Chapparpu

[latifpatel]

Hi,
Thanks for the reply.
Drill thru is successfully.
But thing is that list report changing according to the chart report.
List report should not be change only the chart data is must be change..

EX
ABC
PQR
XYZ
If i click on ABC it must be show data in chart for ABC. But list as it like above .

Thanks


Thanks..

[TheMig]

Hi

I've used this as a guide and successfully created a Drill-Through from a summary pie chart to a child pie chart on the same page

Also, the summary pie does not change, only the child pie does.

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.0.doc%2Ft_cr_rptstd_try_ex_drill_thru_self.html

Cheers
Mig

[latifpatel]

Hi all,
Sorry i forgot to inform that my issue is solve.
We drill down any thing in same report.
Chart to list or list to chart.. etc

Thanks
9860 18 10 84