topic Re: Drill-down reporting in Application Development and Automation Discussions

Drill-down reporting

Former Member — Thu, 30 Nov 2006 03:35:36 GMT

hi experts,

What is a drill-down reporting? What commands are usually used for developing a drill-down report? Many thanks!

Regards,

Marc

Re: Drill-down reporting

Former Member — Thu, 30 Nov 2006 03:45:47 GMT

Hi,

Do you want ALV report or normal list for drill-down..

Thanks,

Naren

Re: Drill-down reporting

Former Member — Thu, 30 Nov 2006 03:47:58 GMT

HI,

Drill down reports can be helpful when user wants to navigate to a transaction. for example, say the list has the sales docuement number in it, user can click on the sales document number and fire VA03.

report zrich_0002 no standard page heading.

data: ivbak type table of vbak with header line.

data : cursor_field(30),

field_value(30) .

select-options: s_vbeln for ivbak-vbeln.

start-of-selection.

select * into corresponding fields of table ivbak

from vbak

where vbeln in s_vbeln.

loop at ivbak.

write:/ ivbak-vbeln.

endloop.

at line-selection.

get cursor field cursor_field value field_value.

case cursor_field.

when 'IVBAK-VBELN'.

set parameter id 'AUN' field field_value.

call transaction 'VA03' and skip first screen..

endcase.

Regards,

Rajesh.

Re: Drill-down reporting

seshatalpasai_madala — Thu, 30 Nov 2006 03:48:55 GMT

Hi,

In a normal report we will be using AT LINE SELECTION and HIDE command. HIDE is used to store the data displayed in a list and to retrive it back on a double click at perticular line on the list. Once the the double click event is generated we go to AT LINE SELECTION event block. where you will generate detail list using WRITE statements.

In a report with ALV this can be done using screens and event handling of some of events of the CL_GUL_ALV_GRID class.

Regards,

Sesh

Re: Drill-down reporting

Former Member — Thu, 30 Nov 2006 03:49:14 GMT

As the name suggests, the user can Interact with the report. We can have a drill down into the report data. For example, Column one of the report displays the material numbers, and the user feels that he needs some more specific data about the vendor for that material, he can HIDE that data under those material numbers. And when the user clicks the material number, another report (actually sub report/secondary list) which displays the vendor details will be displayed.

We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21). Events associated with Interactive Reports are: 1. AT LINE-SELECTION 2. AT USER-COMMAND 3. AT PF<key> 4. TOP-OF-PAGE DURING LINE-SELECTION. HIDE statement holds the data to be displayed in the secondary list. sy-lisel : contains data of the selected line. sy-lsind : contains the level of report (from 0 to 21)

Interactive Report Events:

AT LINE-SELECTION : This Event triggers when we double click a line on the list, when the event is triggered a new sublist is going to be generated. Under this event what ever the statements that are been return will be displayed on newly generated sublist.

AT PFn: For predefined function keys...

AT USER-COMMAND : It provides user functions keys.

Please Mark Useful Answers

Re: Drill-down reporting

Former Member — Thu, 30 Nov 2006 03:55:34 GMT

mostly used events are

AT LINE-SELECTION

AT USER-COMMAND

AT PF<nn>

FOR GETTING THE DATA AFTER DBL CLICK

STATEMENT

GET CURSOR....

HIDE....

regards

Shiba Dutta