Problem in down loading to excel sheet from ALV report

Former Member — Fri, 08 Dec 2006 10:26:25 GMT

Hi Experts,

I have used the funtion module REUSE_ALV_GRID_DISPLAY, and for field catalog I have individually written the field catalog as there are not many fields instead of using the funtion module REUSE_ALV_FIELDCATALOG_MERGE.

Report is getting displayed well but while getting down load to xls only numeric fields are appearing and character fields are not appearing.

Have I selected the function module formats correctly.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_BYPASSING_BUFFER =
I_BUFFER_ACTIVE =
I_INTERFACE_CHECK = ' '

I_CALLBACK_PROGRAM = 'ZHR_DETAILS'

I_CALLBACK_PF_STATUS_SET = ' '
I_CALLBACK_USER_COMMAND = ' '
I_CALLBACK_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_END_OF_LIST = ' '
I_STRUCTURE_NAME =
I_BACKGROUND_ID = ' '

I_GRID_TITLE = 'Active ETA Details'

I_GRID_SETTINGS =
IS_LAYOUT =

IT_FIELDCAT = RT_FCAT

IT_EXCLUDING =
IT_SPECIAL_GROUPS =
IT_SORT =
IT_FILTER =
IS_SEL_HIDE =
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT =
IT_EVENTS =
IT_EVENT_EXIT =
IS_PRINT =
IS_REPREP_ID =
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
I_HTML_HEIGHT_TOP =
I_HTML_HEIGHT_END =
IMPORTING
E_EXIT_CAUSED_BY_CALLER =
ES_EXIT_CAUSED_BY_USER =

TABLES

T_OUTTAB = ITAB

EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Please advice me.

Thanks in advance.

Regards,

Irfan Hussain

Re: Problem in down loading to excel sheet from ALV report

Former Member — Fri, 08 Dec 2006 10:29:28 GMT

what are all the parameters you have passed to build field catalog.

Re: Problem in down loading to excel sheet from ALV report

Former Member — Fri, 08 Dec 2006 10:31:41 GMT

Hi Irfan,

This looks strange !!1

Try to use the layout option also and checkout if it works

topic Re: Problem in down loading to excel sheet from ALV report in Application Development and Automation Discussions

Problem in down loading to excel sheet from ALV report

Re: Problem in down loading to excel sheet from ALV report

Re: Problem in down loading to excel sheet from ALV report