Hi there, I have a RadGrid (Q1 2009 release) and I want to group by the LanguageID that I am pulling from my LinqDataSource while displaying the accompanying Language instead of the ID. I am attempting to use the FieldAlias for the Language, but this is not working. Here is my code. My LinqDataSource is pulling: SurveyID, SurveyGroupID, SurveyGroupName, LanguageID, Language from the database directly. I can group by anything, but no matter what I group by, the FieldAlias does not do anything.
| <telerik:RadGrid ID="rdgSurveys" runat="server" DataSourceID="ldsSurveys" GridLines="None" Skin="Office2007" AutoGenerateColumns="False"> |
| <MasterTableView DataKeyNames="SurveyID" DataSourceID="ldsSurveys" GroupLoadMode="Client"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridButtonColumn Text="Select" CommandName="Select"> |
| </telerik:GridButtonColumn> |
| <telerik:GridEditCommandColumn> |
| </telerik:GridEditCommandColumn> |
| <telerik:GridBoundColumn DataField="SurveyID" DataType="System.Int32" HeaderText="SurveyID" ReadOnly="True" SortExpression="SurveyID" UniqueName="SurveyID"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="SurveyGroupID" DataType="System.Int32" HeaderText="SurveyGroupID" SortExpression="SurveyGroupID" UniqueName="SurveyGroupID" Visible="False" ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="SurveyGroupName" DataType="System.String" HeaderText="SurveyGroupName" SortExpression="SurveyGroupName" UniqueName="SurveyGroupName" Visible="False" ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn DataField="LanguageID" DataType="System.Int32" HeaderText="Language" SortExpression="LanguageID" UniqueName="LanguageID"> |
| <EditItemTemplate> |
| <asp:DropDownList ID="ddlLanguages" runat="server" DataSourceID="ldsLanguages" DataTextField="Language" DataValueField="LanguageID" SelectedValue='<%# Bind("LanguageID") %>' Width="200px"> |
| </asp:DropDownList> |
| </EditItemTemplate> |
| <ItemTemplate> |
| <asp:Label runat="server" ID="lblLanguage" Text='<%# Eval("Language") %>'></asp:Label> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| </Columns> |
| <GroupByExpressions> |
| <telerik:GridGroupByExpression> |
| <SelectFields> |
| <telerik:GridGroupByField FieldName="LanguageID" FieldAlias="Language" HeaderText="Survey Group" /> |
| </SelectFields> |
| <GroupByFields> |
| <telerik:GridGroupByField FieldName="LanguageID" FieldAlias="Language" /> |
| </GroupByFields> |
| </telerik:GridGroupByExpression> |
| </GroupByExpressions> |
| <EditFormSettings> |
| <EditColumn UniqueName="EditCommandColumn1"> |
| </EditColumn> |
| </EditFormSettings> |
| </MasterTableView> |
| <ClientSettings Selecting-AllowRowSelect="True" EnablePostBackOnRowClick="True"> |
| <Selecting AllowRowSelect="True" /> |
| </ClientSettings> |
| <FilterMenu EnableTheming="True"> |
| <CollapseAnimation Type="OutQuint" Duration="200"> |
| </CollapseAnimation> |
| </FilterMenu> |
| </telerik:RadGrid> |