Multiple Grouping - Collapse on last group

[Joshua]

I am using VS 2013 and have the most current Telerik ASP.NET AJAX components loaded.

I have a single view I am accessing and I want to have three groups: Year > Month > Ingredient

I want all child columns under the Ingredient group to be collapsed by default.  I have tried to use the GroupsDefaultExpanded but it seems to collapse everything to the first group (Year).

ASPX code below:

<telerik:RadGrid ID="FutureViewGrid" OnColumnCreated="FutureViewGrid_ColumnCreated" ShowHeader="true" runat="server" SelectMethod="GetFuturesView" ItemType="RawPricing.DataModel.RawPricingFuturesView" AllowFilteringByColumn="True" AllowSorting="True" ShowGroupPanel="True">

                                <ClientSettings Resizing-AllowColumnResize="true" Resizing-ResizeGridOnColumnResize="true" AllowColumnsReorder="True" AllowDragToGroup="True" ReorderColumnsOnClient="True" Resizing-AllowResizeToFit="true">
                                    <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                                </ClientSettings>

                <MasterTableView SelectMethod="GetFuturesView" GroupsDefaultExpanded="false" GroupLoadMode="Server" RetainExpandStateOnRebind="true" EnableGroupsExpandAll="true" >

                    <GroupByExpressions>
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField FieldName="Year"  FieldAlias="Year"/>
                                <telerik:GridGroupByField FieldName="Cost_Change" FieldAlias="CostChange" Aggregate="Sum" FormatString="{0:c}" />
                                <telerik:GridGroupByField FieldName="Amount" FieldAlias="AmountLBS" Aggregate="Sum" FormatString="{0:#,##}" />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="Year" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
                         <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField FieldName="Year"  FieldAlias="Year"/>
                                <telerik:GridGroupByField FieldName="Month" FieldAlias="Month" />
                                <telerik:GridGroupByField FieldName="Cost_Change" FieldAlias="CostChange" Aggregate="Sum" FormatString="{0:c}" />
                                <telerik:GridGroupByField FieldName="Amount" FieldAlias="AmountLBS" Aggregate="Sum" FormatString="{0:#,##}" />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="Month" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField FieldName="Year"  FieldAlias="Year"/>
                                <telerik:GridGroupByField FieldName="Month" FieldAlias="Month" />
                                <telerik:GridGroupByField FieldName="Ingredient" FieldAlias="Ingredient" />
                                <telerik:GridGroupByField FieldName="Cost_Change" FieldAlias="CostChange" Aggregate="Sum" FormatString="{0:c}" />
                                <telerik:GridGroupByField FieldName="Amount" FieldAlias="AmountLBS" Aggregate="Sum" FormatString="{0:#,##}" />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="Ingredient" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
                    </GroupByExpressions>
                </MasterTableView>
            </telerik:RadGrid>

[Konstantin Dikov]

Hello Joshua,

I have tested the following configuration locally and there are no problems with the default group expand functionality:

<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" DataSourceID="SqlDataSource1" runat="server" PageSize="20"
         AllowSorting="True" AllowMultiRowSelection="True" AllowPaging="True" ShowGroupPanel="True"
         AutoGenerateColumns="False" GridLines="none">
         <PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>
         <MasterTableView Width="100%" GroupsDefaultExpanded="false" EnableGroupsExpandAll="true">
             <GroupByExpressions>
                 <telerik:GridGroupByExpression>
                     <SelectFields>
                         <telerik:GridGroupByField FieldAlias="Received" FieldName="Received" FormatString="{0:D}"
                             HeaderValueSeparator=" from date: "></telerik:GridGroupByField>
                     </SelectFields>
                     <GroupByFields>
                         <telerik:GridGroupByField FieldName="Received" SortOrder="Descending"></telerik:GridGroupByField>
                     </GroupByFields>
                 </telerik:GridGroupByExpression>
                 <telerik:GridGroupByExpression>
                     <SelectFields>
                         <telerik:GridGroupByField FieldAlias="FolderName" FieldName="FolderName"></telerik:GridGroupByField>
                     </SelectFields>
                     <GroupByFields>
                         <telerik:GridGroupByField FieldName="FolderName"></telerik:GridGroupByField>
                     </GroupByFields>
                 </telerik:GridGroupByExpression>
             </GroupByExpressions>
             <Columns>
                 <telerik:GridBoundColumn SortExpression="Received" HeaderText="Received" HeaderButtonType="TextButton"
                     DataField="Received" DataFormatString="{0:d}">
                 </telerik:GridBoundColumn>
                 <telerik:GridBoundColumn SortExpression="From" HeaderText="From" HeaderButtonType="TextButton"
                     DataField="From">
                 </telerik:GridBoundColumn>
                 <telerik:GridBoundColumn SortExpression="FolderName" HeaderText="Folder name" HeaderButtonType="TextButton"
                     DataField="FolderName">
                 </telerik:GridBoundColumn>
                 <telerik:GridBoundColumn SortExpression="Size" HeaderText="Size" HeaderButtonType="TextButton"
                     DataField="Size">
                 </telerik:GridBoundColumn>
             </Columns>
         </MasterTableView>
         <ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True">
             <Selecting AllowRowSelect="True"></Selecting>
             <Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True"
                 ResizeGridOnColumnResize="False"></Resizing>
         </ClientSettings>
         <GroupingSettings ShowUnGroupButton="true"></GroupingSettings>
     </telerik:RadGrid>
 <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"
     ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM Mails" runat="server"></asp:SqlDataSource>

I have to say that from the provided screenshot and the description it is not clear what the actual problem is, so if the problem persists, please provide additional information on the exact issue.


Regards,
Konstantin Dikov
Telerik by Progress