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

Client-side grouping

11 Answers 330 Views

Grid

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

11 Answers, 1 is accepted

answered on 19 Mar 2009, 04:45 AM

Hi Ryan,

I tried Grouping the RadGrid on the client side and it is working well. Try setting the GroupLoadMode property of the Grid to client and see if it works.

ASPX:

    
            <MasterTableView  GroupLoadMode="Client" >

    
            <input id="Button1" type="button" value="button"  onclick="Group();" />

JS:

    
                function Group()  
        
                  {  
        
                   var masterTable = $find("<%=RadGrid1.ClientID%>").get_masterTableView();  
        
                   masterTable.groupColumn("Country");  
        
                  }

Thanks
Shinu

answered on 19 Mar 2009, 05:45 AM

Hi Shinu,

Thanks for that. But it still does not work for me. I actually tried that before. What it does is that it raises the onCommand client event of the RadGrid. I can see from the event arguments the GroupByColumn commandName. So do I need to manually create a group header item and group every item to that group or is it automatically created for me. Thanks. Below is my declaration of my radgrid. Can you also post a sample project where you actually made it work? Thanks.

telerik:RadGrid ID="RadGrid1" EnableViewState="false" runat="server" AllowPaging="True" AllowSorting="True" AllowMultiRowSelection="true" AutoGenerateColumns="false" ShowStatusBar="true" ShowFooter="false" ShowHeader="true">

<telerik:GridClientSelectColumn UniqueName="Select" DataType="System.Boolean" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="1%" />

<telerik:GridBoundColumn UniqueName="UpdatedOn" HeaderText="<%$ Resources:ForumResource, DateUpdated %>" DataField="UpdatedOn" SortExpression="Dateupdated" DataFormatString="{0:ddMMMyyyy}" ConvertEmptyStringToNull="true" ItemStyle-Width="6%" ItemStyle-HorizontalAlign="Center" />

<telerik:GridBoundColumn UniqueName="UpdatedBy" HeaderText="<%$ Resources:ForumResource, UpdatedBy %>" DataField="UpdatedBy" SortExpression="UpdatedBy" ConvertEmptyStringToNull="true" ItemStyle-Width="10%" ItemStyle-HorizontalAlign="Center" />

<telerik:GridBoundColumn UniqueName="ForumID" HeaderText="<%$ Resources:ForumResource, ForumId %>" DataField="ForumID" SortExpression="ForumID" ConvertEmptyStringToNull="true" ItemStyle-Width="9%" ItemStyle-HorizontalAlign="Center" />

<telerik:GridBoundColumn UniqueName="Topic" HeaderText="<%$ Resources:ForumResource, Topic %>" DataField="Topic" SortExpression="Topic" ConvertEmptyStringToNull="true" ItemStyle-Width="30%" />

<telerik:GridBoundColumn UniqueName="Category" HeaderText="<%$ Resources:ForumResource, Category %>" DataField="Categorycode" SortExpression="Category" ConvertEmptyStringToNull="true" ItemStyle-Width="8%" ItemStyle-HorizontalAlign="Center" />

<telerik:GridBoundColumn UniqueName="Commentcount" HeaderText="<%$ Resources:ForumResource, CommentCount %>" DataField="Commentcount" SortExpression="Commentcount" DataType=System.Int32 ConvertEmptyStringToNull="true" ItemStyle-Width="4%" ItemStyle-HorizontalAlign="Center" />

<telerik:GridBoundColumn UniqueName="P" HeaderText="<%$ Resources:ForumResource, Priority %>" DataField="P" SortExpression="Priority" ConvertEmptyStringToNull="true" ItemStyle-Width="4%" ItemStyle-HorizontalAlign="Center" />

<telerik:GridBoundColumn UniqueName="Dateopened" HeaderText="<%$ Resources:ForumResource, InitiatedOn %>" DataField="Dateopened" SortExpression="Dateopened" DataFormatString="{0:ddMMMyyyy}" ConvertEmptyStringToNull="true" ItemStyle-Width="6%" ItemStyle-HorizontalAlign="Center" />

<telerik:GridTemplateColumn UniqueName="InitMod" HeaderText="<%$ Resources:ForumResource, InitMod %>" ItemStyle-Width="10%" ItemStyle-HorizontalAlign="Center" >

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn UniqueName="ModeratedBy" HeaderText="<%$ Resources:ForumResource, Moderator %>" DataField="ModeratedBy" SortExpression="ModeratedBy" ConvertEmptyStringToNull="true" Visible="false" ItemStyle-HorizontalAlign="Left" />

<telerik:GridBoundColumn UniqueName="InitiatedBy" HeaderText="<%$ Resources:ForumResource, Initiator %>" DataField="InitiatedBy" SortExpression="InitiatedBy" ConvertEmptyStringToNull="true" Visible="false" ItemStyle-HorizontalAlign="Left" />

<telerik:GridBoundColumn UniqueName="Status" HeaderText="<%$ Resources:ForumResource, Status %>" DataField="Status" SortExpression="Status" ConvertEmptyStringToNull="true" Visible="false" />

<telerik:GridBoundColumn UniqueName="State" HeaderText="<%$ Resources:ForumResource, State %>" DataField="State" SortExpression="State" ConvertEmptyStringToNull="true" Visible="true" />

</Columns>

<asp:Label ID="noRecords" runat="server" Text="<%$ Resources:Labels, NoRecords %>"></asp:Label>

</NoRecordsTemplate>

</MasterTableView>

</ClientSettings>

<StatusBarSettings LoadingText="<%$ Resources: Labels,Loading%>" ReadyText="<%$ Resources: Labels,Ready%>" />

</telerik:RadGrid>

answered on 06 Jul 2009, 09:35 AM

Hi,

I have same problem. I can not make the grouping work. Here the aspx and code behind code

    
            <asp:ScriptManager ID="ScriptManager1" runat="server">  
        
                    </asp:ScriptManager> 
        
                    <telerik:radajaxmanager id="RadAjaxManager1" runat="server">  
        
                        <AjaxSettings> 
        
                            <telerik:AjaxSetting AjaxControlID="RadGrid1">  
        
                                <UpdatedControls> 
        
                                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" /> 
        
                                </UpdatedControls> 
        
                            </telerik:AjaxSetting> 
        
                        </AjaxSettings> 
        
                    </telerik:radajaxmanager> 
        
                    <telerik:radajaxloadingpanel id="RadAjaxLoadingPanel1" runat="server">  
        
                    </telerik:radajaxloadingpanel> 
        
                    <telerik:radgrid id="RadGrid1" allowmultirowselection="true" allowpaging="true" autogeneratecolumns="false" 
        
                        runat="server" allowsorting="True" gridlines="None" onneeddatasource="RadGrid1_OnNeedDataSource" 
        
                        showgrouppanel="True">  
        
                        <MasterTableView Width="100%" GroupLoadMode="Client" TableLayout="Fixed">            
        
                            <Columns> 
        
                                <telerik:GridBoundColumn SortExpression="Title" HeaderText="Title" HeaderButtonType="TextButton" 
        
                                    DataField="Title" DataFormatString="{0:d}">  
        
                                </telerik:GridBoundColumn> 
        
                            </Columns> 
        
                        </MasterTableView> 
        
                        <ClientSettings ReorderColumnsOnClient="false" AllowDragToGroup="True" AllowColumnsReorder="True">  
        
                            <Selecting AllowRowSelect="True"></Selecting> 
        
                            <Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True" 
        
                                ResizeGridOnColumnResize="False"></Resizing> 
        
                        </ClientSettings> 
        
                    </telerik:radgrid>

Code Behind

    
            protected void RadGrid1_OnNeedDataSource(object sender, EventArgs e)  
        
                    {  
        
                        DataTable table = new DataTable();  
        
                        table.Columns.Add("Title", typeof(string));  
        
                        table.Rows.Add("Record 1");  
        
                        table.Rows.Add("Record 2");  
        
                        table.Rows.Add("Record 3");  
        
                        table.Rows.Add("Record 4");  
        
                        table.Rows.Add("Record 5");  
        
                        RadGrid1.DataSource = table;  
        
                    }

answered on 06 Jul 2009, 10:21 AM

Hello guys,

@Ryan:
Grouping with client-side binding is not supported in the present version of RadGrid for ASP.NET AJAX. We will consider this feature for implementation for the future releases of the product.

@Chris:
From the grid definition you provided it seems that you omit to set the ClientSettings -> AllowGroupExpandCollapse property to true as shown on this RadGrid demo:

http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/grouploadmodeclient/defaultcs.aspx

Can this be the reason for not being able to expand/collapse groups with GroupLoadMode set to Client?

Kind regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.