on 11-08-2011 7:37 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.