topic Re: Interactive reports list in Application Development and Automation Discussions

Interactive reports list

Former Member — Fri, 21 Mar 2008 09:53:13 GMT

 Reports: I want to jump from 2nd detail list to 10th list. Is it possible? How?

 Suppose Iam in 10th list , I want to move to 3nd list directly? How?

Re: Interactive reports list

Former Member — Fri, 21 Mar 2008 10:14:33 GMT

Hi,

1 .List index can be controlled using the system variable

SY-LSIND..so, u can use this variable to call the 10th list as

sy-lsind = 10.

Re: Interactive reports list

Former Member — Fri, 21 Mar 2008 10:16:44 GMT

Hi,

EX:

REPORT demo_list_interactive_2 .

START-OF-SELECTION.

WRITE: 'Basic List, SY-LSIND =', sy-lsind.

AT LINE-SELECTION.

IF sy-lsind = 15.

sy-lsind = 5.

ENDIF.

WRITE: 'Secondary List, SY-LSIND =', sy-lsind.

Re: Interactive reports list

Former Member — Fri, 21 Mar 2008 10:18:17 GMT

Hi,

 Reports: I want to jump from 2nd detail list to 10th list. Is it possible? How?

 Suppose Iam in 10th list , I want to move to 3nd list directly? How?

The system variable sy-lsind will hold the current list index.

at line-selection.

If sy-lsind = 2.

if sy-ucomm = 'LI10'.

sy-lsind = 10.

endif.

Reward.

Re: Interactive reports list

Former Member — Fri, 21 Mar 2008 10:22:21 GMT

The system variable sy-lsind will hold the current list number.

at line-selection.

If sy-lsind = 2.

if sy-ucomm = 'LI10'.

sy-lsind = 10.

endif.

elseif sy-lsind = 10.

if-sy-ucomm = 'LI03'.

sy-lsind = 3.

endif.

Reward.

Re: Interactive reports list

Former Member — Thu, 17 Apr 2008 14:41:31 GMT

Interactive Reports

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:

AT LINE-SELECTION

AT USER-COMMAND

AT PF<key>

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.

TOP-OF-PAGE DURING LINE-SELECTION :top of page event for secondary list.

MAX we can go for 20 SECONDARY LIST AND ONE BASIC LIST TOTAL 21

sy-lsind EQ 5.

sy-lsind = 9.

endif.

Ex:

REPORT demo_list_interactive_2 .

START-OF-SELECTION.

WRITE: 'Basic List, SY-LSIND =', sy-lsind.

AT LINE-SELECTION.

IF sy-lsind = .5

sy-lsind = 9.

ENDIF.

WRITE: 'Secondary List, SY-LSIND =', sy-lsind.

I just gave an example at this link for filling and retrieving data to a text editor.

reward if usefull.