[Solved] Formatting RadGrid GroupByExpressions

[Brett]

I am trying to format a RadGrid which contains 4 columns. I have a few issues that I don't know how to fix.
1)I want to format that information so that it aligns with the columns
2)How do I change the background color so that it is alternating colors, right now they are all a gray color
3)I want to get rid of the Client number sorting (keep the grouping) and sort by Date of Decline DESCENDING

Here is the code that I have so far:

​<%@ Page Title="Report" Language="C#" MasterPageFile="~/MasterPages/Site.Master" AutoEventWireup="true" CodeBehind="Report.aspx.cs" Inherits="Report" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">

<div>
 <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True"
   AllowPaging="True" AllowSorting="True" CellSpacing="0" GridLines="None"
   PageSize="500" ShowGroupPanel="True">
 <ClientSettings AllowDragToGroup="True">
 </ClientSettings>
 <MasterTableView AutoGenerateColumns="False" DataKeyNames="orderno"
 DataSourceID="SqlDataSource1" GroupsDefaultExpanded="False">
 <RowIndicatorColumn Visible="False">
 </RowIndicatorColumn>
 <ExpandCollapseColumn Created="True">
 </ExpandCollapseColumn>
 <Columns>
 <telerik:GridBoundColumn DataField="custnum" DataType="System.Decimal" FilterControlAltText="Filter custnum column"     HeaderText="Client Number" SortExpression="custnum" UniqueName="custnum">
 </telerik:GridBoundColumn>

 <telerik:GridBoundColumn DataField="event_date" DataType="System.DateTime" FilterControlAltText="Filter event_date column" HeaderText="Date" ReadOnly="True" SortExpression="event_date" UniqueName="event_date">
 </telerik:GridBoundColumn>

 <telerik:GridBoundColumn DataField="orderno" DataType="System.Decimal" FilterControlAltText="Filter orderno column"    HeaderText="Order Number" ReadOnly="True" SortExpression="orderno" UniqueName="orderno">
 </telerik:GridBoundColumn>

 <telerik:GridBoundColumn DataField="statdesc" FilterControlAltText="Filter statdesc column" HeaderText="Order Status" SortExpression="statdesc" UniqueName="statdesc">
 </telerik:GridBoundColumn>
 </Columns>
 <GroupByExpressions>
 <telerik:GridGroupByExpression>
 <SelectFields>
 <telerik:GridGroupByField FieldAlias="custnum" FieldName="custnum" HeaderText=" " HeaderValueSeparator="" />
 </SelectFields>
 <SelectFields>
 <telerik:GridGroupByField FieldAlias="event_date" FieldName="event_date" HeaderText=" " HeaderValueSeparator=" " />
 </SelectFields>
 <SelectFields>
 <telerik:GridGroupByField FieldAlias="orderno" FieldName="orderno" HeaderText=" " HeaderValueSeparator=" " />
 </SelectFields>
 <SelectFields>
 <telerik:GridGroupByField FieldAlias="statdesc" FieldName="statdesc" HeaderText=" " HeaderValueSeparator=" " />
 </SelectFields>
 <GroupByFields>
 <telerik:GridGroupByField FieldAlias="custnum" FieldName="custnum" FormatString="" HeaderText="" />
 </GroupByFields>
 </telerik:GridGroupByExpression>
 </GroupByExpressions>
 <PagerStyle AlwaysVisible="True" Mode="NextPrevNumericAndAdvanced" Position="TopAndBottom" />
 </MasterTableView>

 </telerik:RadGrid>
 </div>
 <br />
 <asp:SqlDataSource ID="SqlDataSource1" runat="server"
 ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
 SelectCommand="Report"
 SelectCommandType="StoredProcedure">
 </asp:SqlDataSource>

</asp:Content>

[Princy]

Hi Brett,

To align the items on Grouping under its column, please have a look at this article on Aligning Items in GroupHeader.
You can set the BackColor of the GroupHeaderItems using the <GroupHeaderItemStyle />. To have the sorting by date, you can set the <SortExpressions> of the Grid.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server"..>
  <GroupHeaderItemStyle BackColor="White" /
     <MasterTableView>
       <SortExpressions>
          <telerik:GridSortExpression FieldName="DateOfDecline" SortOrder="Descending" />
       </SortExpressions>
     </MasterTableView>
</telerik:RadGrid>

Thanks,
Princy