This is a migrated thread and some comments may be shown as answers.

Rad Grid - Grouping - Default Collapsed

14 Answers 1640 Views

Grid

This is a migrated thread and some comments may be shown as answers.

14 Answers, 1 is accepted

answered on 01 Sep 2008, 02:35 PM

Hello Michael,

Here is an example:

    
            <%@ Page Language="C#" %> 
        
            <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <script runat="server"> 
        
                protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e) 
        
                { 
        
                    System.Collections.Generic.List<object> list = new System.Collections.Generic.List<object>(); 
        
                    for (int i = 0; i < 10; i++) 
        
                    { 
        
                        list.Add(new { ID = i, Name = String.Format("Name{0}", (i < 5)? 1 : 2) }); 
        
                    } 
        
                    RadGrid1.DataSource = list; 
        
                } 
        
                protected void Page_PreRender(object sender, EventArgs e) 
        
                { 
        
                    RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader)[1].Expanded = false; 
        
                } 
        
            </script> 
        
            <html xmlns="http://www.w3.org/1999/xhtml"> 
        
            <head runat="server"> 
        
                <title></title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server"> 
        
                <div> 
        
                    <asp:ScriptManager ID="ScriptManager1" runat="server" /> 
        
                    <telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"> 
        
                        <MasterTableView> 
        
                            <GroupByExpressions> 
        
                                <telerik:GridGroupByExpression> 
        
                                    <GroupByFields> 
        
                                        <telerik:GridGroupByField FieldName="Name" /> 
        
                                    </GroupByFields> 
        
                                    <SelectFields> 
        
                                        <telerik:GridGroupByField FieldName="Name" /> 
        
                                    </SelectFields> 
        
                                </telerik:GridGroupByExpression> 
        
                            </GroupByExpressions> 
        
                        </MasterTableView> 
        
                    </telerik:RadGrid> 
        
                </div> 
        
                </form> 
        
            </body> 
        
            </html>

Greetings,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

answered on 01 Sep 2008, 03:28 PM

Hi Vlad,

Thanks for the snippet and quick reply.. I'll give it a try and let you know how it get on.

In the mean time I have another problem with grouping that perhaps you can help me with.

I have 2 levels of grouping on my grid using 2 GridGroupByExpression objects created in the Page_Load(). I also have an aggregate on one of the fields to be shown in the group footer.

Individually the two groups work fine (adding one at a time and testing), however when I add them both together I get two problems.

1) The top level expand/collapse button does not work properly, I can still see the entries of the group but it removes the expand/collapse buttons of the sub groups? If I then press the expand button again it returns to normal but with all the level 2 groups collapsed (hope that makes sense?)

2) The aggregate values (sum) for the first group are only calculating values for the last sub group in its group.

For example, if I have 2 level 1 groups and each has 3 level 2 groups.. if i look at the totals for each of the 3 sub levels in the first group they are correct (i.e. 3), but the total top level group sum is the same as the last sub group (i.e. 3 instead of 9).

I hope all of that makes sense?

Mike

answered on 03 Sep 2008, 12:25 PM

Hi Vlad,

I have found work around to my second 2 questions there although I still think they may be problems, especially point 2.

I have however found another possible issue with grouping and your first suggestion for having groups collapsed by default.

For some reason if I trap the PreRender event the grid does not have any items.. this is a little strange as the data binding has already taken place, I have solved this by placing your suggestion in the OnDataBound event of the grid.

But there seems to be a problem with the group footers when an entry is collapsed by default as it still shows the group footer. If I then expand and collapse the group again it goes away.

I have a feeling I might be able to work around this by trapping the OnItemCreated event and hiding the footer item if its parent is collapsed but its not ideal.

Any suggestions?

Thanks

answered on 05 Sep 2014, 08:11 AM

Dear Michael,
i had a similar problem with you with GroupFooters:
"But there seems to be a problem with the group footers when an entry is collapsed by default as it still shows the group footer. If I then expand and collapse the group again it goes away."

and i managed to solved it with the above code

Private Sub RadGrid1_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemCreated
For Each gi As GridGroupHeaderItem In RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader)
If gi.Expanded = True Then
gi.Expanded = False
End If
Dim children As GridItem() = gi.GetChildItems()
For Each child As GridItem In children
If child.Expanded = True Then
child.Expanded = False
End If
If child.ItemType = GridItemType.GroupFooter Then child.Visible = False
Next
'gi.Expanded = False
Next

the trick was this:
If child.ItemType = GridItemType.GroupFooter Then child.Visible = False

i think this will be helpful for others.

End Sub

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Rad Grid - Grouping - Default Collapsed

14 Answers, 1 is accepted