Sorting Not working of SAP Crystal Reports Exported excel sheet

Question

I have multiple columns in report i want to sort excel sheet for blank records but it showing first record then blank rows and then other records, Other excel sheets working properly what do i have to do setting or change in crystal report?

Answer 1

Hi @Shivdatta

Could you share some screenshots with us to show more details, such as the sorting results?
And tell us which columns you select to sort, from A to Z, or Z to A?

Please check whether there are merged cells or hidden cells in this report.

Besides, as the worksheet is reported from SAP, it's also recommended to post a thread on SAP community.
(Please Note: Since the web site is not hosted by Microsoft, the link may changed without notice. Microsoft does not guarantee the accuracy of this information.)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---