Sorting Not working of SAP Crystal Reports Exported excel sheet

Shivdatta 1 Reputation point
2022-11-30T14:06:19.83+00:00

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?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,601 Reputation points
    2022-12-01T06:27:35.8+00:00

    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.


    0 comments No comments