<%@ Page Language="C#" AutoEventWireup="true" CodeFile="grid_sample.aspx.cs"
    Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>RadGrid</title>
    <style type="text/css">
        div.RadGrid td.templateCell
        {
           padding: 0;    
        }

        div.RadGrid td.templateCell table
        {
            height: 40px;
        }
    
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager ID="scriptManager" runat="server">
    </telerik:RadScriptManager>
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">

        </script>
    </telerik:RadCodeBlock>
    <telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1">
        <telerik:RadGrid ID="grdCurrentandPrior" runat="server" AllowRowResize="True" AllowSorting="True"
            AutoGenerateColumns="False" GridLines="Horizontal" Skin="Web20" Style="margin-right: 0px"
            Width="897px" Height="252px" OnNeedDataSource="RadGrid_NeedDataSource">
            <ExportSettings FileName="OpenItemsCurrentInventory" IgnorePaging="True" OpenInNewWindow="True"
                ExportOnlyData="true" Excel-Format="ExcelML">
            </ExportSettings>
            <MasterTableView CommandItemDisplay="Bottom" AllowNaturalSort="false" UseAllDataFields="true">
                <CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false"
                    ShowRefreshButton="false" />
                <Columns>
                    <telerik:GridTemplateColumn DataField="Assignee" HeaderText="Assignee" UniqueName="Assignee"
                        SortExpression="Assignee">
                        <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                        <ItemTemplate>
                            <asp:Label ID="lbAssignee" runat="server" Text='<%# Eval("Assignee") %>'></asp:Label>
                        </ItemTemplate>
                        <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn DataField="State" HeaderText="State" UniqueName="State"
                        SortExpression="State" Visible="false">
                        <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                        <ItemTemplate>
                            <asp:Label ID="lbState" runat="server" Text='<%# Eval("State") %>'></asp:Label>
                        </ItemTemplate>
                        <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn DataField="JurisdictionCount" HeaderText="Jurisdictions"
                        UniqueName="JurisdictionCount" SortExpression="JurisdictionCount">
                        <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />
                        <ItemTemplate>
                            <asp:Label ID="lbJurisdiction" runat="server" Text='<%# Eval("JurisdictionCount", "{0:N0}")%>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                        <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn UniqueName="OpenItemsByAge">
                        <ItemStyle CssClass="templateCell" />
                        <HeaderTemplate>
                            <table id="Table1" cellspacing="0" cellpadding="0" width="100%" border="0">
                                <tr>
                                    <td colspan="3" align="center">
                                        <b>Open Items by Age</b>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="center" style="width: 33%">
                                        <asp:LinkButton CssClass="Button" ID="btnPrioOpen" Text="Prior" CommandName='Sort'
                                            CommandArgument='OpenItemsCountPrior' runat="server" />
                                    </td>
                                    <td align="center" style="width: 33%">
                                        <asp:LinkButton CssClass="Button" ID="btnLastMonth" Text="Last Month" CommandName='Sort'
                                            CommandArgument='OpenItemsCountLastMonth' runat="server" />
                                    </td>
                                    <td align="center" style="width: 34%">
                                        <asp:LinkButton CssClass="Button" ID="btnCurrentOpen" Text="Current" CommandName='Sort'
                                            CommandArgument='OpenItemsCountCurrent' runat="server" />
                                    </td>
                                </tr>
                            </table>
                        </HeaderTemplate>
                        <ItemTemplate>
                            <table id="Table2" cellspacing="0" cellpadding="0" width="100%" border="0" style="margin: 0px 0px 0px 0px;">
                                <tr>
                                    <td align="right" width="33%" style="border-bottom-color: White; border-left-color: White">
                                        <%# Eval("OpenItemsCountPrior", "{0:N0}") %>
                                    </td>
                                    <td align="right" width="33%" style="border-bottom-color: White">
                                        <%# Eval("OpenItemsCountLastMonth", "{0:N0}")%>
                                    </td>
                                    <td align="right" width="34%" style="border-bottom-color: White">
                                        <%#  Eval("OpenItemsCountCurrent", "{0:N0}") %>
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn DataField="TotalRemainingItems" HeaderText="Items Left to Pay"
                        UniqueName="TotalRemainingItems" SortExpression="TotalRemainingItems">
                        <HeaderStyle Font-Bold="True" Width="95px" HorizontalAlign="Center" Font-Names="Arial" />
                        <ItemTemplate>
                            <asp:Label ID="lblTotalRemain" runat="server" Text='<%# Eval("TotalRemainingItems", "{0:N0}") %>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                        <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn DataField="CompleteCount" HeaderText="Complete" UniqueName="CompleteCount"
                        SortExpression="CompleteCount">
                        <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />
                        <ItemTemplate>
                            <asp:Label ID="lblCompleteCount" runat="server" Text='<%# Eval("CompleteCount", "{0:N0}") %>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                        <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn DataField="PercentComplete" HeaderText="% Complete" UniqueName="clmPctComplete"
                        SortExpression="PercentComplete">
                        <HeaderStyle Font-Bold="True" Width="85px" HorizontalAlign="Center" Font-Names="Arial" />
                        <ItemTemplate>
                            <asp:Label ID="lblPctComplete" runat="server" Text='<%# Eval("PercentComplete", "{0:N2}%")%>'></asp:Label>
                        </ItemTemplate>
                        <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                        <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                    </telerik:GridTemplateColumn>
                </Columns>
            </MasterTableView>
            <HeaderStyle BorderStyle="Solid" />
            <ClientSettings>
                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
            </ClientSettings>
        </telerik:RadGrid>
    </telerik:RadAjaxPanel>
    </form>
</body>
</html>
