Cannot get grid to perform grouping

2 posts, 0 answers
  1. Bill
    Bill avatar
    175 posts
    Member since:
    Apr 2010

    Posted 23 Jan 2013 Link to this post

    I need to convert an SSRS report that I developed into a Telerik grid which does similiar grouping (see attached files).

    Notice that in the SSRS rpt, the data is grouped by CruiseLine, Ship, and Date. I want that same kind of grouping (not the look, just the correct grouping) in the Telerk Grid, but cannot achieve that desired result.

    I've read articles and searched the web about this topic. I've tried several different things, but I just can't get it to group data on those fields.

    The detail data is coming out fine (see attached file "telerik grp") with the correct display in the Group Header.

    I don't know where the top line (CruiseLine, Ship, and Date) comes from via my grid. I don't see any properties that would display that. I'm not interested in any sorting, just grouping. btw, when I click on any of those 3, the grid just disappears.

    Below, is my code for the grid.

    Can somebody please help me achieve what should be, a simple grouping, and point out what I'm doing wrong that needs to be corrected?

    <telerik:radgrid id="RadGrid1" runat="server" GridLines="None" AutoGenerateColumns="False" AllowPaging="True" ShowGroupPanel="True"
                            ShowFooter="True" >
                            <PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>
                            <MasterTableView GroupsDefaultExpanded="false" GroupLoadMode="Client" ShowGroupFooter="True" pagesize="50"
                                <RowIndicatorColumn Visible="True"
                                    <HeaderStyle Width="20px"></HeaderStyle>
                                <ExpandCollapseColumn Visible="True"
                                    <HeaderStyle Width="19px"></HeaderStyle>
                                    <telerik:GridBoundColumn DataField="CruiseLine" ReadOnly="true">
                                    <telerik:GridBoundColumn DataField="Ship" ReadOnly="true">
                                    <telerik:GridBoundColumn DataField="Date" ReadOnly="true" DataFormatString="{0:M/d/yyyy}">
                                    <telerik:GridBoundColumn DataField="Product1Cash" ReadOnly="true" DataFormatString="{0:C2}">
                                    <telerik:GridBoundColumn DataField="Product2Cash" ReadOnly="true" DataFormatString="{0:C2}">
                                    <telerik:GridBoundColumn DataField="Product3Cash" ReadOnly="true" DataFormatString="{0:C2}">
                                    <telerik:GridBoundColumn DataField="Product4Cash" ReadOnly="true" DataFormatString="{0:C2}">
                                    <telerik:GridBoundColumn DataField="Product5Cash" ReadOnly="true" DataFormatString="{0:C2}">
                                    <telerik:GridBoundColumn DataField="Product6Cash" ReadOnly="true" DataFormatString="{0:C2}">
                                    <telerik:GridBoundColumn DataField="Sales" ReadOnly="true" DataFormatString="{0:C2}">
                                      <telerik:GridGroupByField FieldName="CruiseLine" />
                                      <telerik:GridGroupByField FieldName="Ship" />
                                      <telerik:GridGroupByField FieldName="Date" FormatString="{0:M/d/yyyy}" />
                                      <telerik:GridGroupByField FieldName="CruiseLine" />
                                      <telerik:GridGroupByField FieldName="Ship" />
                                      <telerik:GridGroupByField FieldName="Date" FormatString="{0:M/d/yyyy}" />
  2. Maria Ilieva
    Maria Ilieva avatar
    4017 posts

    Posted 28 Jan 2013 Link to this post

    Hello Bill,

    In case you need to remove the group panel that represents the group by fields form the top of the grid you could simply set ShowGroupPanel="false" for the RadGrid control. As for the Grid disappearing issue I suppose that you are binding the RadGrid with simple Databinding as I do not see any handlers for the NeedDataSource control or decoratively set DataSource. If this is the case please note that the Grouping feature is not supported with simple data bonding but you should use advanced binding as described below:

    Maria Ilieva
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top