Drill down report

[Former Member]

Hi all,

I have to develop drill down report, at least it should drill down up to 3 levels or 3 lists in the first list it should display sum of customer values, after clicking on the particular customer it should drill down into details like that it should drill down up to at least 3 lists...

which method is better, performance wise and simple..

is hierarchical lists FM will server my purpose ?

thanks

[Former Member]

you can use GET CURSOR FIELD method through activiting hotspot and hide statements.

Regards

R.Rajendran

[Former Member]

Maybe u can check this program - BCALV_GRID_02

when the user clicks a row its going for next level ALV ( but as a pop up. still you can use the same idea for displaying normal grid ALV )

I dont find hierarchical list alv necessary for ALV drill down. are you confused between drill down and expand functionalities?

If you use hierarchical ALV list then you can go for 2 level display ( like header details with a + symbol in left corner and if click it the list will display the corresponding item lines. this is called expand and not drill down )

Drill down means. clicking a column will display a corresponding new ALV list itself. In this way, you can go to any number of drilling downs to new ALV lists.

Cheers

Kothand

[Former Member]

going for alv grid is the best way since its look and feel will be good, coding is very easy fixing bug in alv grid is also easy. and even the user can directly go to 3rd screen if he done want to go to second screen.