Drillthrough on different Data Item value

[Gyana]

Hi All,

        I a facing a problem while developing my report. I have a Data item call KPI_ID with some values. I want to do a drillthrough on different IDs.

KPI_ID
=======
01
02
03

When the KPI_ID= 01 then it ll go to a KPI 01 report
                KPI_ID= 02 then it ll go to a new report KPI 02.
Similarly for KPI_ID =3, It link to different report.

Please help me how to achieve that

[charon]

hi sekhar,

i have no idea how to achieve a data-depending (values 1, 2 or 3 in your case) drillthrough definition to different reports directly, but i have some ideas you might wanne try.
1) create one "big" reports as canvas for your 3 detail reports, and work with variables. put each report in a block and set boxtype to "none" depending on the values. Therefore, only 1 "report" in your big report will be shown.
2) (my favourite): create string variable, unlock the cells for KP_ID and put in blocks with different links. Then, dependin on the value of kp_id, set boxtype of the blocks with the links of non depending of the value defined in the string value. so this should show onle the Link you put in the box (like KP 1, KP 2 , Kp 3) to each of your reports.

just some ideas though...gl and have a nice weekend
cheerz :)

[Gyana]

Hi Charon,

            Thanks for reply. I achieve my the requirement.



Regards,
Sekhar

[mitwa]

how? can you explain me properly