topic interactive report doubt in Application Development and Automation Discussions

interactive report doubt

Former Member — Mon, 11 Jun 2007 10:46:45 GMT

Hi all,

In interactive reports how to get value of filed which user clicked on.

I'm using GET CURSOR FIELD, it's returing field name not value.

Any other ways to catch field value???

please help....

Re: interactive report doubt

seshatalpasai_madala — Mon, 11 Jun 2007 10:51:13 GMT

Hi,

Please check the documentation for key word HIDE.

You can use HIDE to get the values from detail list.

Example:

DATA: square TYPE i,

cube TYPE i.

START-OF-SELECTION.

FORMAT HOTSPOT.

DO 10 TIMES.

square = sy-index ** 2.

cube = sy-index ** 3.

WRITE / sy-index.

HIDE: square, cube.

ENDDO.

AT LINE-SELECTION.

WRITE: square, cube.

Regards,

Sesh

Message was edited by:

Seshatalpasai Madala

Re: interactive report doubt

Former Member — Mon, 11 Jun 2007 10:52:24 GMT

Hi,

check this example.

REPORT ZBHREP3 LINE-COUNT 15(1) LINE-SIZE 75.

TABLES: SFLIGHT,ZEMP.

DATA VAR LIKE SFLIGHT-CONNID.

DATA ITAB LIKE SFLIGHT OCCURS 0 WITH HEADER LINE.

PARAMETERS NAME TYPE ZEMP-NAME DEFAULT 'BHARAT'.

WRITE: 25 NAME COLOR 6.

SELECT-OPTIONS CARRID1 FOR SFLIGHT-CARRID.

SET PF-STATUS 'MENU'.

SET TITLEBAR 'TIT'.

FORMAT HOTSPOT ON.

WRITE:/10 'AIRLINE CODE',25 'CONNECTION ID',40 'FLIGHT DATE'.

SELECT * FROM SFLIGHT WHERE CARRID IN CARRID1.

WRITE:/10 SFLIGHT-CARRID,25 SFLIGHT-CONNID,40 SFLIGHT-FLDATE.

ENDSELECT.

*END-OF-PAGE.

END-OF-PAGE.

WRITE:/64 'P.NO:',SY-PAGNO.

*TOP-OF-PAGE.

TOP-OF-PAGE.

WRITE:/ 'THIS IS MY FIRST REPORTS PROGRAM.'.

*START-OF-SELECTION.

START-OF-SELECTION.

DO 5 TIMES.

WRITE:/ SY-INDEX.

ENDDO.

*THESE 3 STATEMENTS ARE FOR THE END-OF-PAGE CONTENTS IN LAST PAGE.

DATA M TYPE I.

M = SY-LINCT - SY-LINNO - 1.

SKIP M.

*AT LINE-SELECTION.

AT LINE-SELECTION.

CASE SY-LSIND.

WHEN '1'.

READ LINE SY-LILLI FIELD VALUE SFLIGHT-CONNID INTO VAR.

SELECT * FROM SFLIGHT INTO CORRESPONDING FIELDS OF ITAB WHERE

CONNID = VAR.

WRITE:/ ITAB-CARRID,ITAB-PLANETYPE,ITAB-PAYMENTSUM.

ENDSELECT.

WRITE:/ VAR.

WHEN '2'.

WRITE:/ SY-LILLI.

WHEN '3'.

WRITE 😕 'BHARAT'.

ENDCASE.

rgds,

bharat.

Re: interactive report doubt

Former Member — Mon, 11 Jun 2007 10:54:45 GMT

hi,

follow this logic........

*declare variables for holding the field name and field value

DATA: fname(10) type c.

fvalue(10) type c.

**syntax for selecting data

GET CURSOR FIELD fname VALUE fvalue .

regards,

Ashokreddy.

Re: interactive report doubt

Former Member — Mon, 11 Jun 2007 10:55:40 GMT

FULL SYNTAX IS

GET CURSOR FIELD FNAM VALUE FVAL.

HERE FVAL WILL CONTAIN THE VALUE AND FNAM IS CONTAINING THE FIELD NAME .

REGARDS

SHIBA DUTTA

Re: interactive report doubt

Former Member — Mon, 11 Jun 2007 11:23:51 GMT

Try like this.

Data: fnam(20) type c,

val type vbak-vbeln.

Get cursor field fnam value val.

Regards

Haritha.