Skip to Content
author's profile photo Balakumar Viswanathan
0
Balakumar Viswanathan

Rows missing while exporting to Excel

Posted on Nov 08, 2011 at 07:37 AM 138 Views

One of my client's system environment is SAP 2007A PL:42, Excel 2000

While exporting the query results to excel without sorting, its exporting the whole records (nearly 13000 lines). If I sort with Column-A, its exporting nearly 12500 records only. Even strange is that, if I sort with Column-B, its exporting only 12000 records.

In all sorts, the SAP is displaying the whole 13000 records, but problem is in Excel export only.

Regards,

Bala

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2011 at 01:32 PM
    1

    Hi Bala,

    Long time no see. In such volume for exporting, you need to keep the original before sorting. Another option would be use Order By to get the initial result you want.

    Anyway, Excel has better and fasting sorting functions. There is no need to sort before exporting. Database has its own limitation. When you manipulate data to show them in the form, you lose some other to be exported correctly.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

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.