<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BalanceComprobacion.aspx.cs" Inherits="BalanceComprobacion" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Src="~/ControlUsuario/pl_pie.ascx" TagName="pl_pie" TagPrefix="uc1" %>

<!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>Balance Comprobacion</title>
    <link href="estilos/Estilos.css" rel="stylesheet" type="text/css" />
    <script language="javascript" type="text/javascript" src="JavaScript/actb.js"></script>
    <script language="javascript" type="text/javascript" src="JavaScript/common.js"></script>
    <script language="javascript" type="text/javascript" src="JavaScript/SGH_Script.js"></script>    
 
 <telerik:RadCodeBlock ID="RadCodeBlock2" runat="server">
 <script>
     function PrintRadGrid() {
         var previewWnd = window.open('about:blank', '', '', false);
         var sh = '<%= ClientScript.GetWebResourceUrl(tk_Grid.GetType(), String.Format("Telerik.Web.UI.Skins.{0}.Grid.{0}.css", tk_Grid.Skin))%>';
         var styleStr = "<html><head><link href = '" + sh + "' rel='stylesheet' type='text/css'></link></head>";
         var htmlcontent = styleStr + "<body>" + $find('<%= tk_Grid.ClientID%>').get_element().outerHTML + "</body></html>";
         previewWnd.document.open();
         previewWnd.document.write(htmlcontent);
         previewWnd.document.close();
         previewWnd.print();
         previewWnd.close();
     }
 </script>
 
 </telerik:RadCodeBlock>
    
    <script type="text/javascript" language="JavaScript">
        function cerrar() {
        var ventana = window.self;
        ventana.opener = window.self;
        parent.close();
        }
        //nbernuy
     

        //nbernuy
      function requestStart(sender, args)
        {
            if (args.get_eventTarget().indexOf("ExcelExport") != -1)
                args.set_enableAjax(false);
            if (args.get_eventTarget().indexOf("PDFExport") > 0)
                args.set_enableAjax(false);
            if (args.get_eventTarget().indexOf("WordExport") > 0)
                args.set_enableAjax(false);
            if (args.get_eventTarget().indexOf("CSVExport") > 0)
                args.set_enableAjax(false);
            if (args.get_eventTarget().indexOf("Print") > 0)
                args.set_enableAjax(false);
        }   
        function Regresar() {
            
            var ventana = window.self;
            ventana.opener = window.self;
            ventana.opener.focus();
    }
  
        function CerraryRegresar() {
            var ventana = window.self;
            ventana.opener = window.self;
            parent.close();
        }
                                                     
    </script>

    

    <style type="text/css">
        .style1
        {
            font-family: Arial, Helvetica, sans-serif;
            font-size: 11px;
            font-style: normal;
            line-height: normal;
            font-weight: normal;
            color: #000000;
            height: 26px;
        }
        </style>

    

    </head>
<body>

    
    <form id="form2" runat="server" method="post"  defaultfocus="txtUsuario">
    

    <asp:ScriptManager ID="ScriptManager1" runat="server" />
  
     <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Telerik" />
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1" ClientEvents-OnRequestStart="requestStart">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="tk_Grid">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="tk_Grid" LoadingPanelID="RadAjaxLoadingPanel1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
             <telerik:AjaxSetting AjaxControlID="btnActualizarr">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="tk_Grid" LoadingPanelID="RadAjaxLoadingPanel1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>

      <table  style="height:455px; width:100%" cellpdading="0" cellspacing="0" border="0">
      <tr>
        <td align="center" valign="middle">
          <table width="100%" cellpadding="0" cellspacing="0" border="0" 
                style="height:435px; background-color: #FFFFFF;">
            <tr>
              <td colspan="2" style="height:7px" bgcolor="#FFFFFF"></td>
            </tr>
            <tr>
              <%--<td align=right colspan="2" style="height:20px" bgcolor="#A9CE53" ><a href="#" class="linksblanco" onClick="cerrar()"> Cerrar</a>&nbsp;&nbsp</td>--%>
              <td>
              
              <table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                        <td style="width:1px; padding-left:20px">
                            <img id="Img4" runat="server" src="~/images/TitleLeftLightBlue.png" alt="" />
                        </td>
                        <td background="images/LineBodySky.png" style="width:15px; padding-left:5px; text-align:left; vertical-align:middle;" class="tituloseccion">
                            <img id="img5" runat="server" src="images/Report.png" border="0" />                             
                        </td>
                        <td background="images/LineBodySky.png" style="padding-left:10px; text-align:left; vertical-align:middle;" class="tituloseccion">                            
                           <asp:Label ID="lblTitulo" runat="server" Text=""></asp:Label>
                           <asp:Label ID="lblAcumulado" runat="server"  Text="">
                           </asp:Label><asp:Label ID="lblnik" runat="server"></asp:Label>&nbsp;Mes de
                           <asp:Label ID="lblMes" runat="server" Text="Label"></asp:Label>
                           &nbsp;<asp:Label ID="lblEjercicio" class="tituloseccion" runat="server" Text="Label"></asp:Label>
                           &nbsp;Expresado en <asp:Label ID="lblMonedaNombre" runat="server" Text="Label"></asp:Label>
                        </td>
                        <td background="images/LineGray.png" style="width:20px;display:none; padding-left:10px; vertical-align:bottom;">
                            <a href="BusquedaInteligente.aspx" class="gridtext">
                                <img id="img15" runat="server" src="images/Back.png" border="0" />                                            
                            </a>                            
                        </td>
                        <td background="images/LineGray.png" style="display:none;width:20px" class="gridtextbold">
                            <a href="#" class="gridtext"  onClick="Regresar()">Atras</a>
                            <%--<asp:LinkButton runat="server" ID="l1" Text="Inicio2" onclick="l1_Click"></asp:LinkButton>--%>
                        </td>
                        <td background="images/LineGray.png" style="width:20px; padding-left:15px; vertical-align:middle;" class="gridtextbold">
                            <a href="#" class="gridtext"  onClick="cerrar()">
                                <img id="img6" runat="server" src="images/close.png" border="0" />                                            
                            </a>
                        </td>                 
                        <td background="images/LineGray.png" style="width:20px; padding-right:5px; vertical-align:middle;" class="gridtextbold">
                            <a href="#" class="gridtext"  onClick="CerraryRegresar()">Cerrar</a>
                        </td>
                        <td style="text-align:right; width:1px; padding-right:20px" 
                            <img id="Img7" class="gridtext" runat="server" src="~/images/TitleRightLightGray.png" alt="" />
                        </td>
                    </tr>
                    <tr>
                        <td colspan="8" align="left" style="padding-left:20px">
                            <asp:Label CssClass="gridtextgray" ID="Label8" runat="server" Text="Sucursal: "></asp:Label>
                            &nbsp;
                            <asp:Label CssClass="gridtextgray" ID="lblSucursal" runat="server" Text="Label"></asp:Label>
                            &nbsp;
                            <asp:Label CssClass="gridtextgray" ID="Label7" runat="server" Text="Unidad de Negocio: " Width="110px"></asp:Label>
                            &nbsp;
                            <asp:Label CssClass="gridtextgray" ID="lblUnidadNegocio" runat="server" Text="Label"></asp:Label>
                            &nbsp;
                            <asp:Label CssClass="gridtextgray" ID="Label11" runat="server" Text="Area: "></asp:Label>
                            &nbsp;
                            <asp:Label CssClass="gridtextgray" ID="lblArea" runat="server" Text="Label"></asp:Label>
                            &nbsp;
                            <span class="gridtextgray">Moneda: </span>
                            <asp:Label CssClass="gridtextgray" ID="lblMoneda" runat="server" Text="Label"></asp:Label>
                            &nbsp;
                            <%--<span class="gridtextgray">Desde: </span>
                            <asp:Label CssClass="gridtextgray" ID="lblDesde" runat="server" Text="Label" ></asp:Label>
                            &nbsp;
                            <span class="gridtextgray">Hasta: </span>
                            <asp:Label CssClass="gridtextgray" ID="lblHasta" runat="server" Text="Label"></asp:Label>--%>
                            
                        </td>
                    </tr>
        </table>
         </td>
            </tr>

            <tr>
              <td colspan="2" align="center">
              
              <table id="Table3" cellspacing="0" cellpadding="0" width="97%" border="0">  
        <tr>
            <td align="center" class="arial10bold" style="height: 15px;" valign="top">
                &nbsp;</td>
        </tr>
        
        <tr>
            <td align="left" class="style1" valign="bottom" style="height: 5px;">
                    
            </td>
        </tr>
        
         <tr align="center" valign="middle">
            <td style="height: 45px;">
                <table width="100%" border="0" cellpadding="0" cellspacing="0" >
                    <tr>
                                <td style="width:50px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;" align="right">
                                     <asp:Label ID="Label1" runat="server" CssClass="gridtext" AssociatedControlID="cbxMoneda">Moneda&nbsp</asp:Label>
                                 </td>
                                 <td align="left" style="width:70px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <telerik:RadComboBox ID="cbxMoneda" Runat="server" 
                                          Skin="Outlook" Width="120px" 
                                         >
                                     </telerik:RadComboBox>
                                     </td>
                                 <td align="right" style="width:40px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                 <asp:Label ID="Label4" runat="server" CssClass="gridtext" AssociatedControlID="cbxMoneda">Nivel&nbsp</asp:Label>
                                    </td>
                                 <td align="left" style="width:97px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <telerik:RadComboBox ID="cbxNivelCuentas" Runat="server" 
                                         Skin="Outlook" Width="97px" >
                                     </telerik:RadComboBox>
                                 </td>
                                 <td align="right" style="width:60px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <asp:Label ID="Label3" runat="server" CssClass="gridtext" AssociatedControlID="cbxAcumulado">Tipo&nbsp;</asp:Label>
                                 </td>
                                 <td align="left" style="width:160px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <telerik:RadComboBox ID="cbxAcumulado" Runat="server" EnableLoadOnDemand="False" 
                                         onitemsrequested="cbxAcumulado_ItemsRequested" Skin="Outlook" 
                                         Width="130px" OnSelectedIndexChanged="cbxAcumulado_SelectedIndexChanged">
                                     </telerik:RadComboBox>
                                     <%--<telerik:RadComboBox ID="cbxTipoCuenta1" Runat="server" 
                                         EnableLoadOnDemand="False" 
                                         Skin="Office2007" Width="500px" DropDownWidth="495px" onitemsrequested="cbxTipoCuenta1_ItemsRequested" >
                                     </telerik:RadComboBox>--%>
                                 </td>
                                 <td style="width:10px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                    &nbsp;
                                 </td>
                                 <td align="left" style="border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <asp:Button ID="btnActualizar" runat="server" class="Button" 
                                          Text="Actualizar" Width="80px" onclick="btnActualizar_Click" />
                                 </td>
                       

                    </tr>
                </table>
            </td>
                                 
        
        <tr>
            <td align="center">
                
                         
                        <table border="0" style="border: #CCCCCC 1px solid; width: 100%; height:100%">
                            <tr>
                                <td style="text-align: center; height: 21px; padding: 4px;">
                                                                    
                                 <telerik:RadGrid                                              
                                            AutoGenerateColumns="False" 
                                            ID="tk_Grid" 
                                            PageSize="100" 
                                            Height="480px"
                                             Width="1300px"
                                            runat="server"
                                            style="margin-top: 0px" 
                                            BorderStyle="None"
                                            AllowFilteringByColumn="True"                                          
                                            onitemdatabound="tk_Grid_ItemDataBound" 
                                        onneeddatasource="tk_Grid_NeedDataSource" onprerender="tk_Grid_PreRender" 
                                        Skin="Office2007" onitemcommand="tk_Grid_ItemCommand" Culture="es-ES"
                                            >    
                                            
                                        <%--    <HeaderStyle HorizontalAlign="Center" ForeColor="White" />
                                            <EditItemStyle BackColor="#EAFFEA" />
                                            <ActiveItemStyle BackColor="#333300" />--%>
                                                                                                                                                                
                                        
                                        <GroupingSettings ShowUnGroupButton="True" CollapseTooltip="" ExpandTooltip="" 
                                            GroupContinuedFormatString="... Vienen" 
                                            GroupContinuesFormatString="Van..." 
                                             GroupSplitDisplayFormat="" />
                                        
                                        
                                        <GroupingSettings CaseSensitive="False" />
                                        
                                        
                                        <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true" >
                                            <Pdf PageWidth="560mm" />
                                        </ExportSettings>
                                        <ClientSettings EnableRowHoverStyle="true">
                                            <Selecting AllowRowSelect="True"/>
                                            <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                                        </ClientSettings>
                                            
                                        <AlternatingItemStyle HorizontalAlign="Center" />
                                        
                                        
                                        <GroupHeaderItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                        
                                        <MasterTableView  CommandItemDisplay="Top" CellSpacing="0" ShowGroupFooter="true" AllowMultiColumnSorting="true" 
                                                            ShowFooter="false" EditMode="PopUp">  
                                        <CommandItemTemplate>
                                          <asp:ImageButton runat="server" ID="ExcelExport" ImageUrl="~/images/page_excel.png" CommandName="ExportExcel" AlternateText="Excel" ToolTip="Excel" /> 
                                            <%--  <asp:ImageButton runat="server" ID="PDFExport" ImageUrl="~/images/page_acrobat.png" CommandName="ExportPDF" AlternateText="Pdf" ToolTip="Pdf" />
                                            <asp:ImageButton runat="server" ID="WordExport" ImageUrl="~/images/page_word.png" CommandName="ExportWord" AlternateText="Word" ToolTip="Word" />
                                            <asp:ImageButton runat="server" ID="CSVExport" ImageUrl="~/images/page_csv.png" CommandName="ExportCSV" AlternateText="CSV" ToolTip="CSV" />
                                            --%>
                                            <asp:ImageButton runat="server" ID="Print" ImageUrl="~/images/printer.png" CommandName="Print" AlternateText="Print" ToolTip="Imprimir" />
                                        </CommandItemTemplate>
                                        
                                    
                
                                        
<PagerStyle PageSizeControlType="RadComboBox"></PagerStyle>

                                        <CommandItemStyle CssClass="" HorizontalAlign="Right" />
                                        
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column" Created="True"></ExpandCollapseColumn>
                                        
                                            <Columns>                                                                                                                                                                                                                                                   
                                                    <%-- nbernuy --%> 
                                             

                                              
                                                <telerik:GridBoundColumn Aggregate="none" DataField="PlanCuentaID" FilterControlWidth="100%" ShowFilterIcon="false" Display="false"
                                                    HeaderText="PlanCuentaID" FooterAggregateFormatString="{0:g}" HeaderStyle-Width="75px" AutoPostBackOnFilter="true"
                                                    CurrentFilterFunction="StartsWith">

<HeaderStyle Width="75px"></HeaderStyle>

                                                    <ItemStyle CssClass="gridtex" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn> 
                                               
                                                <%-- nbernuy --%>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="CodigoPlanCuenta" FilterControlWidth="100%" ShowFilterIcon="false"
                                                    HeaderText="Codigo" FooterAggregateFormatString="{0:g}" HeaderStyle-Width="75px" AutoPostBackOnFilter="true"
                                                    CurrentFilterFunction="StartsWith">

<HeaderStyle Width="75px"></HeaderStyle>

                                                    <ItemStyle CssClass="gridtex" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn> 
                                                                          
                                                <telerik:GridBoundColumn Aggregate="none" DataField="NombrePlanCuenta"   FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    HeaderText="Descripcion" FooterAggregateFormatString="{0:g}" >

<HeaderStyle ></HeaderStyle>

                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                 </telerik:GridBoundColumn> 
                                                 
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="DebeSI" DataType="System.Decimal"  FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    HeaderText="Debe Saldo Inicial" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="100px" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>

                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="HaberSI" DataType="System.Decimal"  FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    HeaderText="Haber Saldo Inicial" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="100px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>

                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="DebeMov" DataType="System.Decimal"  FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    HeaderText="Movimiento Debe" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="100px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>

                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="HaberMov" DataType="System.Decimal"  FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    HeaderText="Movimiento Haber" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="100px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>

                                                 <telerik:GridNumericColumn Display="false" Aggregate="Sum" DataField="Debe" DataType="System.Decimal"  FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    HeaderText="Debe" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                 
                                                 <telerik:GridNumericColumn Display="false" Aggregate="Sum" DataField="haber" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="Haber" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                        
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="SaldoDeudor" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="Saldos Deudor" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="100px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                 
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="SaldoAcreedor" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="Saldos Acreedor" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="100px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                 
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="Activo" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                 
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="Pasivo" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>    
                                                 
                                                     
                                                 
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="PerdidaPorFuncion" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                 
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="GananciaPorFuncion" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px"/>
                                                    <ItemStyle  HorizontalAlign="Right" CssClass="gridtext" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>

                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="PerdidaPorNaturaleza" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px"/>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                 
                                                 <telerik:GridNumericColumn Aggregate="Sum" DataField="GananciaPorNaturaleza" DataType="System.Decimal" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
                                                    HeaderText="" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}" AllowFiltering="False">
                                                     <HeaderStyle HorizontalAlign="Center" Width="75px" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                 </telerik:GridNumericColumn>
                                                 
                                                 <telerik:GridBoundColumn DataField="CodigoPlanCuenta2Digitos" Display="false" FooterAggregateFormatString="{0:g}"
                                                    HeaderText="CodigoPlanCuenta2Digitos" HeaderStyle-HorizontalAlign="Right" FooterStyle-HorizontalAlign="Right" >
                                                     <FooterStyle HorizontalAlign="Right" />
                                                     <HeaderStyle HorizontalAlign="Right" />                                                                                                       
                                                 </telerik:GridBoundColumn>
                                                 
                                                                                                                                                                          
                                                                                                                                                                                                                                             
                                            </Columns>
                                            
                                            <GroupByExpressions>                
                                                                                                                            
                                                <telerik:GridGroupByExpression>                                                
                                                    <GroupByFields>                                                                                                        
                                                        <telerik:GridGroupByField FieldName="CodigoPlanCuenta2Digitos"/> 
                                                    </GroupByFields>
                                                    <SelectFields>
                                                        <telerik:GridGroupByField FieldName="CodigoPlanCuenta2Digitos" HeaderText="Grupo" />
                                                    </SelectFields>
                                                    
                                                </telerik:GridGroupByExpression>
                                                                                              
                                            </GroupByExpressions>
                                            
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>

                                            <GroupHeaderItemStyle HorizontalAlign="Left" CssClass="gridtext" Font-Size="12px" />
                                            
                                           
                                        </MasterTableView>
                                        
                                        <FooterStyle Font-Bold="true" />
                                                                                                                                                                
                                        <PagerStyle Mode="NextPrevAndNumeric" PageButtonCount="15" />
                                        
<FilterMenu EnableImageSprites="False"></FilterMenu>

                                        <HeaderContextMenu Skin="Inox">
                                            <CollapseAnimation Duration="200" Type="OutQuint" />
                                        </HeaderContextMenu>
                                        
                                    </telerik:RadGrid>
                                    
                                </td>
                                
                            </tr>
                        </table>
                        
                    <Triggers>
                        <asp:AsyncPostBackTrigger ControlID="btnActualizarr" EventName="Click" />
                    </Triggers>
            </td>
        </tr>
    </table>
              
              
              </td>
            </tr>
            <tr>
              <td colspan="2" style="height:40px">
                  
                  <uc1:pl_pie ID="pl_pie1" runat="server" />
                  
              </td>

            </tr>
          </table>
        </td>
      </tr>
         
      </table>
    </form>
</body>
</html>
