[Solved] Grouping issue with RadGrid

[Pradeep]

Hi Telerik,

I have an issue with the RadGrid.
I have grouped the records in the grid using the "Grouping" property of RadGrid. The grouping is done for the names of certain persons. Here is the associated code:

<GroupByExpressions>
<telerik:GridGroupByExpression> 
<SelectFields> 
<telerik:GridGroupByField FieldName="Name" HeaderText="Name" />
</SelectFields>  
<GroupByFields> 
<telerik:GridGroupByField FieldName="Name" HeaderText="Name" />
</GroupByFields> 
</telerik:GridGroupByExpression> 
</GroupByExpressions>

The grouping works fine. But the names appear in their alphabetical order and I dont want that.
I'm binding the data from database. I have given the "order by" clause, but still its not working. I want the names appear in the grid in the order they are stored in the database table. I think the grouping has caused the problem.

Can you please suggest a way to avoid the alphabetical order display while grouping?

Thanks,
Pradeep Y. 

[Shinu]

Hi Pradeep,

Try setting the SortOrder property to None and see if it helps.

ASPX:

<GroupByExpressions>
                      <telerik:GridGroupByExpression>
                       <GroupByFields>
                        <telerik:GridGroupByField  FieldAlias="Name" FieldName="Name"   SortOrder="None" />
                       </GroupByFields>
                       <SelectFields>
                       <telerik:GridGroupByField  FieldAlias="Name" FieldName="Name"   />
                       </SelectFields>
                      </telerik:GridGroupByExpression>
                    </GroupByExpressions>

Shinu

[Pradeep]

Hi Shinu,

Thanks for your reply.
But its not working with the SortOrder specified. Still the same ordered display.
Please help me someway.

Thanks,
Pradeep Y.

[Badrinarayanan]

Hi,
Even i am facing the same problem with Grouped Grid.  The attribute SortOrder="None" does not work properly.

[Princy]

Hello Badrinarayanan,

The following link to a forum discussion should provide some insights on the sceario you want. Take a look t it and see if it helps:
GroupBy Sorting

Hope this helps..
Princy.