<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="forecast.aspx.cs" EnableEventValidation="false"  Inherits="VMT.forecast" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <script src="resource_gallery/js/ShowHide.js"></script>
    <style type="text/css">
        .auto-style2 {
            width: 100%;
            padding: 6px;
        }
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cphJavaScriptContentPlaceHolder" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="cphPageTitleContentPlaceHolder" runat="server">
     <div id="CssPageTitle">
        <h1>
            Forecast

        </h1>
    </div>
    <div id="SubPageTitle">
        <!-- OPTIONAL SUB PAGE TITLE -->
     
    </div>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="cphMainContentPlaceHolder" runat="server">
     <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
 <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                    <ContentTemplate>
             <div id="loaderdiv">
    <asp:updateprogress id="UpdateProgress1" runat="server" associatedupdatepanelid="UpdatePanel2" dynamiclayout="true">
                        <progresstemplate>

                           <img src="resource_gallery/graphics/loader.gif" class="ajax-loader">

                        </progresstemplate>
                    </asp:updateprogress>

                    </div>          
<div style="text-align:right;"><a href="default.aspx">Home</a> <strong>&#8249;&#8249;</strong> <a href="CurrentYTD.aspx">Current</a> <strong>&#8249;&#8249;</strong> Forecast</div>
 <div style="text-align:left; width: 100%;">
                            <fieldset class="masterform">
                                <legend>Select Business Unit and Year</legend>
                                <div style=" width: 100%; height:60px; ">
                                    
                                    <table class="auto-style2">
                                        <tr>
                                            <td style="width: 20%">Business Unit</td>
                                            <td style="width: 20%">Forecast By</td>
                                            <td style="width: 20%">Year</td>
                                            <td style="width: 20%">Group By</td>
                                            
                                            <td style="width: 20%" rowspan="2">
                                              
                                                <asp:Button ID="btnGo" runat="server" CssClass="FormButton" OnClick="btn_go_Click" Text="Go" visible ="false"/>
                                              <asp:Button ID="btnExportExcel" runat="server" CssClass="FormButton" OnClick="btnExportExcel_Click" Text="Export To Excel" visible ="false" />
                                            </td>
                                             <td></td>
                                        </tr>
                                        <tr>
                                            <td style="width: 20%">
                                                <asp:DropDownList ID="ddl_Bunit" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddl_Bunit_SelectedIndexChanged" >
                                                </asp:DropDownList>
                                            </td>
                                            <td style="width: 20%">
                                                <asp:DropDownList ID="ddl_optionby" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddl_optionby_SelectedIndexChanged">
                                                    <asp:ListItem Selected="True" Text="- Select -" Value="- Select -"></asp:ListItem>
                                                    <asp:ListItem Value="Cycle_Year">Cycle Year</asp:ListItem>
                                                    <asp:ListItem Value="Work_Year">Work Year</asp:ListItem>
                                                    <asp:ListItem Value="Actual_Year">Actual Year</asp:ListItem>
                                                </asp:DropDownList>
                                            </td>
                                            <td style="width: 20%">
                                                <asp:DropDownList ID="ddl_Year" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddl_Year_SelectedIndexChanged">
                                                </asp:DropDownList>
                                            </td>
                                            <td style="width: 20%">
                                                <asp:DropDownList ID="ddl_groupby" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddl_groupby_SelectedIndexChanged">                                   
                                                    <asp:ListItem Text="- Select -" Selected="True" Value="- Select -"></asp:ListItem>
                                                    <asp:ListItem Text="Section/WA" Value="Work Area"></asp:ListItem>
                                                    <asp:ListItem Text="Company" Value="Company"></asp:ListItem>
                                                    <asp:ListItem Text="Project/Event" Value="Event Code" ></asp:ListItem>     
                                                    <asp:ListItem Text="Project/Event-Company" Value="Event Code-Company"></asp:ListItem>
                                                    <asp:ListItem Text="BOE Report" Value="BOE Report"></asp:ListItem>
                                                </asp:DropDownList>
                                            </td>
                                           
                                        </tr>
                                    </table>
                                    
                                </div>
                            </fieldset></div>
                        <div style="text-align:left; width: 100%;">
                            <fieldset class="masterform">
                                <legend>Forecast</legend>
                               <div style=" width: 99%; overflow-x: scroll; position: relative;  " > <br />
                                <div id="griddiv" runat="server" style=" width: 5440px; height:200px; overflow-y: scroll;"><br />
                                    
                                    <asp:GridView ID="gdv_Rate_Company" runat="server" BorderColor="#014567" CellPadding="3"  
                                        Width="100%" AutoGenerateColumns="TRUE" ShowFooter="True" OnRowDataBound="gdv_Rate_Company_RowDataBound" 
                                        OnSorting="gdv_Rate_Company_Sorting" AllowSorting="true">
                                       
                                       <%-- <Columns>
                                            <asp:BoundField DataField="work_area_id" HeaderText="WORK AREA" >
                                            </asp:BoundField>
                                            <asp:BoundField DataField="Company" HeaderText="COMPANY" >
                                            </asp:BoundField>
                                            <asp:BoundField DataField="RATE_TYPE" HeaderText="TRIM TYPE" >
                                            </asp:BoundField>
                                          
                                            <asp:BoundField DataField="RATE" HeaderText="RATE" />
                                            <asp:BoundField DataField="LineLength" HeaderText="LENGTH(mile)" />
                                            <asp:BoundField DataField="Amount" HeaderText="AMOUNT($)" />
                                           
                                        </Columns>--%>
                                        <HeaderStyle BackColor="#98C8DE" Font-Bold="True" />
                                        <SelectedRowStyle BackColor="#FFE98F" />
                                    </asp:GridView>


                                     <asp:GridView ID="gdv_SectionWA" runat="server" BorderColor="#014567" CellPadding="3"  
                                      AutoGenerateColumns="False" ShowFooter="True" Visible ="False"   HeaderStyle-CssClass="FixedHeaderlong"    Width="1454px"
                                        AllowSorting="True" OnSorting="gdv_SectionWA_Sorting" OnRowDataBound="gdv_SectionWA_RowDataBound">
                                       
                                      
                                  
                                           <Columns>
                                               <asp:TemplateField HeaderText="PROJECT/EVENT" SortExpression="PROJECT/EVENT"    HeaderStyle-Width="220px" ItemStyle-Width="231px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("[PROJECT/EVENT]") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[PROJECT/EVENT]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="220px" />
                                                   <ItemStyle Width="231px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="SECTION/WA" SortExpression="SECTION/WA" HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("[SECTION/WA]") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label2" runat="server" Text='<%# Bind("[SECTION/WA]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="90px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TRIMYEAR" SortExpression="TRIMYEAR" HeaderStyle-Width="60px" ItemStyle-Width="71px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="60px" />
                                                   <ItemStyle Width="71px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="ROWTYPE" SortExpression="ROWTYPE"  HeaderStyle-Width="90px" ItemStyle-Width="101px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("ROWTYPE") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="ROWTYPE" runat="server" Text='<%# Bind("ROWTYPE") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="COMPANY" SortExpression="COMPANY" HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                    <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("COMPANY") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label5" runat="server" Text='<%# Bind("COMPANY") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TRIM_TYPE" SortExpression="Trim_Type" HeaderStyle-Width="110px" ItemStyle-Width="121px">
                                                  
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("Trim_Type") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label6" runat="server" Text='<%# Bind("Trim_Type") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="UOM" SortExpression="UOM" HeaderStyle-Width="70px" ItemStyle-Width="81px">
                                                   
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("UOM") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label7" runat="server" Text='<%# Bind("UOM") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_UNITS" SortExpression="Ttl_UNITS" HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Skipped_MLS" SortExpression="Skipped_MLS" HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   
                                                    <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="NBill_MLS" SortExpression="NBill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                  
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Bill_MLS" SortExpression="Bill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   
                                                    <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_MLS" SortExpression="Ttl_MLS"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                  
                                                    <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="95px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="BILLABLE" SortExpression="BILLABLE"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                  
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="95px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:BoundField DataField="TOTAL" HeaderText="TOTAL" SortExpression="TOTAL" />
                                           </Columns>
                                       
                                      
                                  
                                           <HeaderStyle BackColor="#98C8DE" Font-Bold="True" Width="1452px"  ForeColor="Black"/>
                                            <SelectedRowStyle BackColor="#FFE98F" />
                                    </asp:GridView>

                                    
                                     <asp:GridView ID="gdv_Company" runat="server" BorderColor="#014567" CellPadding="3"  
                                      AutoGenerateColumns="False" ShowFooter="True" Visible ="False"   HeaderStyle-CssClass="FixedHeaderlong"    Width="1154px"
                                        AllowSorting="True" OnSorting="gdv_Company_Sorting" OnRowDataBound="gdv_Company_RowDataBound" >
                                       
                                      
                                  
                                           <Columns>
                                              <asp:TemplateField HeaderText="COMPANY" SortExpression="COMPANY" HeaderStyle-Width="100px" ItemStyle-Width="111px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("COMPANY") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label5" runat="server" Text='<%# Bind("COMPANY") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TRIMYEAR" SortExpression="TRIMYEAR" HeaderStyle-Width="60px" ItemStyle-Width="71px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                                 <asp:TemplateField HeaderText="ROWTYPE" SortExpression="ROWTYPE"  HeaderStyle-Width="110px" ItemStyle-Width="111px">
                                                  
                                                   <ItemTemplate>
                                                       <asp:Label ID="ROWTYPE" runat="server" Text='<%# Bind("ROWTYPE") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TRIM_TYPE" SortExpression="Trim_Type" HeaderStyle-Width="110px" ItemStyle-Width="121px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("Trim_Type") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label6" runat="server" Text='<%# Bind("Trim_Type") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="UOM" SortExpression="UOM" HeaderStyle-Width="70px" ItemStyle-Width="81px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("UOM") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label7" runat="server" Text='<%# Bind("UOM") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_UNITS" SortExpression="Ttl_UNITS" HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Skipped_MLS" SortExpression="Skipped_MLS" HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="NBill_MLS" SortExpression="NBill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Bill_MLS" SortExpression="Bill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_MLS" SortExpression="Ttl_MLS"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="BILLABLE" SortExpression="BILLABLE"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:BoundField DataField="TOTAL" HeaderText="TOTAL" SortExpression="TOTAL" />
                                           </Columns>
                                       
                                      
                                  
                                           <HeaderStyle BackColor="#98C8DE" Font-Bold="True" Width="1152px"  ForeColor="Black"/>
                                            <SelectedRowStyle BackColor="#FFE98F" />
                                    </asp:GridView>
                                    
                                     <asp:GridView ID="gdv_EventCode" runat="server" BorderColor="#014567" CellPadding="3"  
                                      AutoGenerateColumns="False" ShowFooter="True" Visible ="False" Width="1254px"  HeaderStyle-CssClass="FixedHeaderlong"  
                                        AllowSorting="True" OnSorting="gdv_EventCode_Sorting" OnRowDataBound="gdv_EventCode_RowDataBound"  >
                                       
                                      
                                  
                                           <Columns>
                                               <asp:TemplateField HeaderText="PROJECT/EVENT" SortExpression="PROJECT/EVENT" HeaderStyle-Width="210px" ItemStyle-Width="250px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("[PROJECT/EVENT]") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[PROJECT/EVENT]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                 
                                               </asp:TemplateField>
                                             
                                               <asp:TemplateField HeaderText="TRIMYEAR" SortExpression="TRIMYEAR" HeaderStyle-Width="65px" ItemStyle-Width="71px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="60px" />
                                                   <ItemStyle Width="71px" />
                                               </asp:TemplateField>
                                                 <asp:TemplateField HeaderText="ROWTYPE" SortExpression="ROWTYPE"  HeaderStyle-Width="110px" ItemStyle-Width="111px">
                                                 
                                                   <ItemTemplate>
                                                       <asp:Label ID="ROWTYPE" runat="server" Text='<%# Bind("ROWTYPE") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RATE_TYPE_NAME" SortExpression="RATE_TYPE_NAME" HeaderStyle-Width="115px" ItemStyle-Width="126px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("RATE_TYPE_NAME") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label6" runat="server" Text='<%# Bind("RATE_TYPE_NAME") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="UOM" SortExpression="UOM" HeaderStyle-Width="70px" ItemStyle-Width="81px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("UOM") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label7" runat="server" Text='<%# Bind("UOM") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="70px" />
                                                   <ItemStyle Width="81px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_UNITS" SortExpression="Ttl_UNITS" HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="80px" />
                                                   <ItemStyle Width="81px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Skipped_MLS" SortExpression="Skipped_MLS" HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="90px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="NBill_MLS" SortExpression="NBill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="90px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Bill_MLS" SortExpression="Bill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="90px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_MLS" SortExpression="Ttl_MLS"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="95px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="BILLABLE" SortExpression="BILLABLE"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="95px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:BoundField DataField="TOTAL" HeaderText="TOTAL" SortExpression="TOTAL" />
                                           </Columns>
                                       
                                      
                                        <%--<HeaderStyle CssClass="HeaderFreez" />--%>    
                                           <HeaderStyle BackColor="#98C8DE" Font-Bold="True" Width="1252px"  ForeColor="Black"/>
                                            <SelectedRowStyle BackColor="#FFE98F" />
                                    </asp:GridView>

                                    
                                     <asp:GridView ID="gdv_EventCode_Company" runat="server" BorderColor="#014567" CellPadding="3"  
                                      AutoGenerateColumns="False" ShowFooter="True" Visible ="False"   HeaderStyle-CssClass="FixedHeaderlong"    Width="1374px"
                                        AllowSorting="True" OnSorting="gdv_EventCode_Company_Sorting" OnRowDataBound="gdv_EventCode_Company_RowDataBound"   >
                                       
                                      
                                  
                                           <Columns>
                                               <asp:TemplateField HeaderText="PROJECT/EVENT" SortExpression="PROJECT/EVENT"    HeaderStyle-Width="210px" ItemStyle-Width="250px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("[PROJECT/EVENT]") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[PROJECT/EVENT]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                 
                                               </asp:TemplateField>
                                             
                                               <asp:TemplateField HeaderText="TRIMYEAR" SortExpression="TRIMYEAR" HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label3" runat="server" Text='<%# Bind("TRIMYEAR") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="60px" />
                                                   <ItemStyle Width="71px" />
                                               </asp:TemplateField>
                                                 <asp:TemplateField HeaderText="ROWTYPE" SortExpression="ROWTYPE"  HeaderStyle-Width="110px" ItemStyle-Width="111px">
                                                  
                                                   <ItemTemplate>
                                                       <asp:Label ID="ROWTYPE" runat="server" Text='<%# Bind("ROWTYPE") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="COMPANY" SortExpression="COMPANY" HeaderStyle-Width="100px" ItemStyle-Width="121px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("COMPANY") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label5" runat="server" Text='<%# Bind("COMPANY") %>'></asp:Label>
                                                   </ItemTemplate>
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TRIM_TYPE" SortExpression="TRIM_TYPE" HeaderStyle-Width="115px" ItemStyle-Width="126px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("TRIM_TYPE") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label6" runat="server" Text='<%# Bind("TRIM_TYPE") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="UOM" SortExpression="UOM" HeaderStyle-Width="70px" ItemStyle-Width="81px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("UOM") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label7" runat="server" Text='<%# Bind("UOM") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="70px" />
                                                   <ItemStyle Width="81px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_UNITS" SortExpression="Ttl_UNITS" HeaderStyle-Width="90px" ItemStyle-Width="101px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label8" runat="server" Text='<%# Bind("Ttl_UNITS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="80px" />
                                                   <ItemStyle Width="81px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Skipped_MLS" SortExpression="Skipped_MLS" HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label9" runat="server" Text='<%# Bind("Skipped_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="90px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="NBill_MLS" SortExpression="NBill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label10" runat="server" Text='<%# Bind("NBill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="90px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Bill_MLS" SortExpression="Bill_MLS"  HeaderStyle-Width="90px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label11" runat="server" Text='<%# Bind("Bill_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="90px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="Ttl_MLS" SortExpression="Ttl_MLS"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label12" runat="server" Text='<%# Bind("Ttl_MLS") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="95px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="BILLABLE" SortExpression="BILLABLE"  HeaderStyle-Width="95px" ItemStyle-Width="100px">
                                                   <EditItemTemplate>
                                                       <asp:TextBox ID="TextBox13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:TextBox>
                                                   </EditItemTemplate>
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label13" runat="server" Text='<%# Bind("BILLABLE") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="95px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:BoundField DataField="TOTAL" HeaderText="TOTAL" SortExpression="TOTAL" />
                                           </Columns>
                                       
                                      
                                  
                                           <HeaderStyle BackColor="#98C8DE" Font-Bold="True" Width="1372px"  ForeColor="Black"/>
                                            <SelectedRowStyle BackColor="#FFE98F" />
                                    </asp:GridView>

                                <br /> <br />
                                     <asp:GridView ID="gdv_BOEReport" runat="server" BorderColor="#014567" CellPadding="3"  
                                      AutoGenerateColumns="False" ShowFooter="True" Visible ="False"   HeaderStyle-CssClass="FixedHeaderlongBOE"    Width="5421px"
                                        AllowSorting="True" OnSorting="gdv_BOEReport_Sorting"   >
                                       
                                      
                                  
                                           <Columns>
                                               <asp:TemplateField HeaderText="BUSINESS_UNIT" SortExpression="BUSINESS_UNIT"    HeaderStyle-Width="160px" ItemStyle-Width="161px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[BUSINESS_UNIT]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="EVENTCODE" SortExpression="EVENT_CODE"    HeaderStyle-Width="180px" ItemStyle-Width="181px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[EVENT_CODE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="WORK AREA" SortExpression="WORK_AREA_ID"    HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[WORK_AREA_ID]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="COMPANY" SortExpression="COMPANY_NAME"    HeaderStyle-Width="120px" ItemStyle-Width="121px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[COMPANY_NAME]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="URBAN THIS YEAR" SortExpression="URBANTHISYEAR"    HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[URBANTHISYEAR]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                 
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RURAL THIS YEAR" SortExpression="RURALTHISYEAR"    HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RURALTHISYEAR]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CLIMB THIS YEAR" SortExpression="CLIMBTHISYEAR"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CLIMBTHISYEAR]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="URBAN UNITS ACTUAL" SortExpression="URBAN_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[URBAN_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RURAL UNITS ACTUAL" SortExpression="RURAL_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RURAL_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="100px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CLIMBING UNITS ACTUAL" SortExpression="CLIMBING_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CLIMBING_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="FLAT UNITS ACTUAL" SortExpression="FLAT_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[FLAT_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   <HeaderStyle Width="100px" />
                                                   <ItemStyle Width="100px" />
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="OTHER ACTUAL" SortExpression="OTHER_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[OTHER_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CY_URBAN UNITS ACTUAL" SortExpression="CY_URBAN_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CY_URBAN_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CY_RURAL UNITS ACTUAL" SortExpression="CY_RURAL_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CY_RURAL_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CY_CLIMB UNITS ACTUAL" SortExpression="CY_CLIMBING_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CY_CLIMBING_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CY_FLAT UNITS ACTUAL" SortExpression="CY_FLAT_UNITS_ACTUAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CY_FLAT_UNITS_ACTUAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="URBAN RATE" SortExpression="URBAN_RATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[URBAN_RATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RURAL RATE" SortExpression="RURAL_RATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RURAL_RATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CLIMBING RATE" SortExpression="CLIMBING_RATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CLIMBING_RATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="FLAT RATE" SortExpression="FLAT_RATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[FLAT_RATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="URBAN ACTUAL$" SortExpression="URBAN_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[URBAN_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RURAL ACTUAL$" SortExpression="RURAL_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RURAL_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CLIMBING ACTUAL$" SortExpression="CLIMBING_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CLIMBING_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="FLAT ACTUAL$" SortExpression="FLAT_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[FLAT_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                 
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="URBAN THISYEAR ACTUAL$" SortExpression="URBAN_THISYEAR_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[URBAN_THISYEAR_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RURAL THISYEAR ACTUAL$" SortExpression="RURAL_THISYEAR_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RURAL_THISYEAR_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CLIMBING THISYEAR ACTUAL$" SortExpression="CLIMBING_THISYEAR_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CLIMBING_THISYEAR_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="FLAT THISYEAR ACTUAL$" SortExpression="FLAT_THISYEAR_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[FLAT_THISYEAR_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="FLAT THISYEAR ACTUAL$" SortExpression="FLAT_THISYEAR_ACTUAL$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[FLAT_THISYEAR_ACTUAL$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="URBAN FORECASTED$" SortExpression="URBAN_FORECASTED$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[URBAN_FORECASTED$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                 
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RURAL FORE- CASTED$" SortExpression="RURAL_FORECASTED$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RURAL_FORECASTED$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CLIMBING FORE- CASTED$" SortExpression="CLIMBING_FORECASTED$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CLIMBING_FORECASTED$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="FLAT FORE- CASTED$" SortExpression="FLAT_FORECASTED$"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[FLAT_FORECASTED$]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="URBAN UNITS FORECASTED" SortExpression="URBAN_UNITS_FORECASTED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[URBAN_UNITS_FORECASTED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RURAL_UNITS FORECASTED" SortExpression="RURAL_UNITS_FORECASTED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RURAL_UNITS_FORECASTED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="CLIMB UNITS FORECASTED" SortExpression="CLIMBING_UNITS_FORECASTED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[CLIMBING_UNITS_FORECASTED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="FLAT UNITS FORECASTED" SortExpression="FLAT_UNITS_FORECASTED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[FLAT_UNITS_FORECASTED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TOTAL_NON BILLABLE MILES" SortExpression="TOTAL_NON_BILLABLE_MILES"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[TOTAL_NON_BILLABLE_MILES]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TOTAL BILLABLE MILES" SortExpression="TOTAL_BILLABLE_MILES"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[TOTAL_BILLABLE_MILES]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TOTAL MILES" SortExpression="TOTAL_MILES"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[TOTAL_MILES]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TOTAL FORECASTED" SortExpression="TOTAL_FORECASTED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[TOTAL_FORECASTED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="ACTUAL CURRENT YEAR" SortExpression="ACTUAL_CURRENT_YEAR"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[ACTUAL_CURRENT_YEAR]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="ACTUAL ACCRUED" SortExpression="ACTUAL_ACCRUED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[ACTUAL_ACCRUED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="INVOICE VS FORECASTED" SortExpression="INVOICE_VS_FORECASTED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[INVOICE_VS_FORECASTED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="TRIM DATE" SortExpression="TRIM_DATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[TRIM_DATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="AUDIT DATE" SortExpression="AUDIT_DATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[AUDIT_DATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="PRE   APPROVAL DATE" SortExpression="PRE_APPROVAL_DATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[PRE_APPROVAL_DATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="PAYMENT STATUS" SortExpression="PAYMENT_STATUS"    HeaderStyle-Width="80px" ItemStyle-Width="81px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[PAYMENT_STATUS]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="PAYMENT DATE" SortExpression="PAYMENT_DATE"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[PAYMENT_DATE]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="PAYMENT AMOUNT" SortExpression="PAYMENT_AMOUNT"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[PAYMENT_AMOUNT]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                 
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RATIO CLIMBING" SortExpression="RATIO_CLIMBING"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RATIO_CLIMBING]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RATIO RURAL" SortExpression="RATIO_RURAL"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RATIO_RURAL]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RATIO URBAN" SortExpression="RATIO_URBAN"    HeaderStyle-Width="100" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RATIO_URBAN]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                  
                                               </asp:TemplateField>
                                               <asp:TemplateField HeaderText="RATIO NONBILLED" SortExpression="RATIO_NONBILLED"    HeaderStyle-Width="100px" ItemStyle-Width="101px">
                                                   <ItemTemplate>
                                                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("[RATIO_NONBILLED]") %>'></asp:Label>
                                                   </ItemTemplate>
                                                   
                                               </asp:TemplateField>

                                             
                                              
                                           </Columns>
                                       
                                      
                                  
                                           <HeaderStyle BackColor="#98C8DE" Font-Bold="True" Width="5419px" ForeColor="Black" Wrap="true"/>
                                            <SelectedRowStyle BackColor="#FFE98F" />
                                    </asp:GridView>

                                </div>
                                   </div>
                            </fieldset></div>
                        <div style="text-align:left; width: 100%;">
                            </div>


</ContentTemplate>
            </asp:UpdatePanel>
</asp:Content>

