Sorting fail

[lakshmi jeeva]

Hi,

  I am facing problem in radgridview sorting. Find the attached screenshot.

  As per our spec we have to combine two tables and displaying in the grid.

 table 1: PK,CheckNUmber,Checkdate,KeyRec,PO Number,KeyRecAmount

table 2 : PK, KeyRec,Work order date,Amt.

For both the table KeyRec value is common. We are having one to many relationsships. I mean for tale 1 KeyRec value we are having more than one record in table 2 .

If we are having more tha one record then we have to join as one group as per screen shot(Please see arrow mark records).

In order to do that  i have cleared the values for other columns and i also cleared the border color to white. If it is unique records then the row border color is black.I did this in row_loaded event of gridview. All above said conditions are working fine.

But if i apply sorting then the grouped row(mentioned in arrow marks in screen shot) are not working. How to do sorting for this type of records? In excel we are having PIVOT .Is it possible to create PIVOt concept of sorting in Radgridview?

[Maya]

Hello lakshmi jeeva,

In order to provide you with a more accurate solution, I would need slightly more details about your particular scenario. Are the row containing only a single value for the KeyRec separate items whose other properties have been cleared ? Are you able to sort the other columns? May you provide some code-snippets demonstrating how exactly you achieve this behavior ? 
Generally, a possible solution might be to handle the Sorting event and perform it manually.  

Greetings,
Maya
the Telerik team