Skip to Content
0
Former Member
Jan 11, 2013 at 06:20 AM

ALV Report download issue

131 Views

Hi Experts,

I have delvelope one ALV Report which displays output correctly, now the problem is, if i download it in local file in .xls format it will not shows all the records in XL file. Some records inbetween lost. and if i download it from menu bar LIST-SPREADSHEET and save it with .xls it shows all the records.

I have use following FMs in Report.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = SY-REPID

i_callback_top_of_page = 'TOP_OF_PAGE'

is_layout = LS_LAYOUT

it_fieldcat = IT_FIELDCAT

IT_SORT = LS_SORT

i_default = 'X'

i_save = 'A'

* IMPORTING

TABLES

t_outtab = IT_FINAL

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.

and

FORM TOP_OF_PAGE.

REFRESH it_listheader[].

wa_listheader-info = 'Input Tax Register Report'.

wa_listheader-typ = 'H'.

APPEND wa_listheader TO it_listheader.

CLEAR wa_listheader.

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

EXPORTING

it_list_commentary = IT_LISTHEADER[].

ENDFORM. "top_of_page

Please help me.

Thanks in advance.