I have a custom report in LMS which is working correctly. We got a request to update the labels of the report for 3 fields as part of new release. After modifying and importing into LMS the sort of the records are different than the older report.
There is no change in the report apart from Label update. I have verified the old Report SQL and the New Report SQL no difference. But when i run the report the Old report and new report have different sorting. But the count of records are same.
Could someone help me or guide me, how can i fix the issue.
Thanks in advance for the help.