Drillthrough - How to decide the target based on the data

[ratikant]

Hi Gurus,
I have a requirement like this.

Parent report has a drillthrough on one column. At run time when we click on different link, it should execute different target reports.

Ex.Ã,  Level
Ã,  Ã,  Ã,  Ã, ------------
Ã,  Ã,  Ã,  Ã, Level1Ã,  Ã,  Ã, ---->Ã,  Level11
Ã,  Ã,  Ã,  Ã, Level2Ã,  Ã,  Ã, ---->Ã,  Level12
Ã,  Ã,  Ã,  Ã, Level3Ã,  Ã,  Ã, ---->Ã,  Level13

So when we click on Level1 it should execute Level11 child report
Ã,  Ã,  Ã, when we click on Level2 it should execute Level12 child report
Ã,  Ã,  Ã, when we click on Level3 it should execute Level13 child report

Please provide any solution for this kind of requirement. Its very urgent.

Thanx

[ratikant]

Hi,
I think, I didn't explain my problem/requirement properly. Below is the details.

There are different channels which will be shown in our parent report. Each channel has different levels of hierarchy. Based on the selected channel, we need to navigate to different hierarchies.
Ex.
   Channel                   Level1      Level2      Level3
   Ch01      L001      L002      L003
   Ch02      L001      L002      Null
   Ch03      L001      Null      L003
   
In this above example Ch01 has all three levels data but not for Ch02 and Ch03. In case of Ch03 Level2 data are not available and for CH02, L003 data not available.
1. So how can we directly show the Level3 data when we drillthrough from Channel Ch03.
2. Can we jump to Level3 directly from Ch03?
3. Based on the the Channel values can we target to different child reports at runtime?

Its urgent. I need your help.
Thanks