Skip to Content
author's profile photo Former Member
Former Member

ALV Report download issue

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jan 12, 2013 at 10:28 AM

    First look for OSS notes related to "Excel Spreadsheet export" on your system and your version of Excel. Not every tool is at same level, some are stuck in the good old (xls) 65,536 rows by 256 columns when last have exceeded those limits like (xlsx) 1,048,576 rows by 16,384 columns - Start with Note 1517329 - ALV Spreadsheet Export: Format Overview

    Most standard tools (outside OLE2) that override currently the limit don't actually create Excel up-to-date files, but flat or xml compatible files that Excel will convert correctly. Actual conversion start with (AFAIK) class cl_xlsx_document, exception if of course scn abap2xlsx

    Regards,

    Raymond

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2013 at 09:30 AM

    hi,

    it is because of some format problem . use it with menu spreadsheet itselt . or try %pc in command button.

    hope it helps,

    Vinoth.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 11, 2013 at 08:51 PM

    .XLS format a limit of 65536 rows, it cannot store any more records than that. Is your dataset larger tahn this?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2013 at 09:17 AM

    Hi Gopal,

    Did you check all the sheets of the excel sheet that is downloaded. Because when you download with the button in the ALV to save in excel sheet. It saves the data in multiple sheets.

    Let me know still it does not solve your problem.

    Thanks,

    Tooshar Bendale

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.