cancel
Showing results for 
Search instead for 
Did you mean: 

Rows missing while exporting to Excel

kvbalakumar
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

kvbalakumar
Active Contributor
0 Kudos

Hi Gordon,

Little bit busy with implementation projects...! Misses both the forum and the members too...

Ya, using order by is solving my problem. Still I wonder that the same records are missing if run the query more than one time also (without order by and using sorting in the results of the query preview window). Only this make me to search for some alternative solution!!!

Even I tried by restricting the results by some where class, causes me no problem!

Anyway thanks...

Regards,

Bala

Former Member
0 Kudos

When you hit more memory, the reliability will be lowered. You need to minimize such operation.

Answers (0)