topic Re: Drill down report in Application Development and Automation Discussions

Drill down report

Former Member — Sat, 12 Jul 2008 14:01:01 GMT

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

Re: Drill down report

Former Member — Sat, 12 Jul 2008 15:54:39 GMT

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

Regards

R.Rajendran

Re: Drill down report

Former Member — Sun, 13 Jul 2008 06:09:11 GMT

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

Re: Drill down report

Former Member — Sun, 13 Jul 2008 06:44:55 GMT

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.