Regarding Sorting and Grouping operation on same data grid

[Kiran Kumar Maharana]

Hi Team,

I'm using the SfDataGrid for the report module on my project. We are grouping the particular field but we are unable to perform sorting operations. Is there any update for performing both operations in SfDataGrid? Please help me with this. 

Thanks in Advance

[Vijayarasan Sivanandham]

Hi Kiran Kumar Maharana,

Thank you for contacting Syncfusion Support.

Based on provided information we have checked the reported issue “Regarding Sorting and Grouping operation on same SfDataGrid” and unable to replicate the issue from our end. It is working fine as expected. Please find the tested sample and video demo from our end in the link below,

 

Sample link: https://www.syncfusion.com/downloads/support/forum/168905/ze/SfDataGridDemo-1864092414 

 

Video Link: https://www.syncfusion.com/downloads/support/forum/168905/ze/SortingAndGrouping-477376672

 

Can you please share us below things?         

        1. Provide the replication procedure with video illustration of the reported issue

 

if you are still facing the same issue? If yes, please modify the sample based on your scenario.

It will be helpful for us to check on it and provide you the solution at the earliest. 

Regards, 

Vijayarasan S 

[Kiran Kumar Maharana]

Hi Vijayarasan Sivanandham,

I Run the sample code which is you shared. before sorting ShipId order is 1,3,5,8,4,2,6,9,7,10. After applying Sorting Largest to Smallest then the order is 1,8,5,3,4,2,9,6,10,7.

Expect order is 10,9,8,7,6,5,4,3,2,1.

Is it possible to expected order when grouping?

[Mohanram Anbukkarasu]

Hi Kiran Kumar Maharana, 

Thanks for the update.  

We are able to understand the reported scenario. We would like to let you know that it is the expected behavior of the SfDataGrid. In this case, the records are already grouped based on the ProductName column values. When you apply sorting for the ShipId column, the records will be sorted within the group they already exists. Please let us know if you require any other assistance from us.  

Regards, 

Mohanram A.