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

Formatting RadGrid GroupByExpressions

1 Answer 397 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Brett
Top achievements
Rank 1
Brett asked on 18 Mar 2014, 08:22 PM
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>

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 19 Mar 2014, 09:43 AM
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
Tags
Grid
Asked by
Brett
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or