Hi All,
In a report, how to filter the data in ascending/descending order based on a particular field.
If any property is there, please specify where to apply it.
Thanks !
Hi
On the report layout, under Group Properties, you can set the sorting order.
Regards
Avinash B
I am using SQL Server report builder. Is this option available there too ?
SQL report builder has sorting function.
If not you can use SETCURRENTKEY to sort in AL.
Could SETCURRENTKEY be applied at report level ? I need sorted data in report.
you need to apply the setcurrentkey to the table dataset on your report.
Hey Aloker,
I'm sure you might have solved it long ago but since I saw it then you may want to revisit docs.microsoft.com/.../sort-data-in-a-data-region-report-builder-and-ssrs
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to a top community star!
In our never-ending quest to help the Dynamics 365 Community members get answers faster …
Welcome to the next edition of the Community Platform Update. This is a status …
Stay up to date on forum activity by subscribing.
