<%@ Page Language="C#" AutoEventWireup="true" CodeFile="frmMayorizacion.aspx.cs" Inherits="frmMayorizacion" %>
<%@ 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>Estado Financieros</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>                                                

    <script type="text/javascript" language="javascript">
        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);
        }
                
    </script>
    
    <script type="text/javascript">      
    
    function Imprimir()
    {
        print();
    }
    
    </script>

    <style type="text/css">
        .style2
        {
            height: 8px;
        }
    </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="btnActualizar">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="tk_Grid" LoadingPanelID="RadAjaxLoadingPanel1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            
            
        </AjaxSettings>
    </telerik:RadAjaxManager>


      <table  style="height:455px; width:100%" cellpadding="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" bgcolor="#FFFFFF" class="style2"></td>
            </tr>
            <tr>
              <td>
                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                        <td style="width:1px;">
                            <img id="Img3" runat="server" src="~/images/TitleLeftLightBlue.png" alt="" />
                        </td>
                        <td background="images/LineBodySky.png" style="padding-left:20px; text-align:left" class=" gridtextbold">
                            
                            <asp:Label ID="lblTitulo" runat="server" Text="ESTADOS FINANCIEROS - "></asp:Label>
                            
                        </td>
                        <td background="images/LineGray.png" style="width:20px; padding-left:10px; vertical-align:bottom;">
                            <a href="BusquedaInteligente.aspx" class="gridtext">
                                <img id="imgHome" runat="server" src="images/home.png" border="0" />                                            
                            </a>                            
                        </td>
                        <td background="images/LineGray.png" style="width:20px" class="gridtextbold">
                            <a href="#" class="gridtext"  onClick="Regresar()">Inicio</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" class="gridtextbold">
                            <a href="#" class="gridtext"  onClick="cerrar()">
                                <img id="img2" runat="server" src="images/close.png" border="0" />                                            
                            </a>
                        </td>                 
                        <td background="images/LineGray.png" style="width:20px; padding-right:5px" class="gridtextbold">
                            <a href="#" class="gridtext"  onClick="CerraryRegresar()">Cerrar</a>
                        </td>
                        <td style="text-align:right; width:1px;">
                            <img id="Img1" class="gridtext" runat="server" src="~/images/TitleRightLightGray.png" alt="" />
                        </td>
                    </tr>
                </table>
              </td>
            </tr>
            <tr>
              <td align="center" colspan="2" style="height:5px">
                
              </td>
            </tr>
            <tr>
              <td colspan="2" align="center">
              
              <table id="Table3" cellspacing="0" cellpadding="0" width="100%" border="0">
        <tr>
            <td align="center" class="tituloseccion" style="height: 10px;">
                
            </td>
        </tr>
        <tr>
            <td colspan="3" align="center">
               
                         <table id="Table4" align="center" border="0" cellpadding="2" cellspacing="0" 
                             style="width: 100%; height: 40px;">
                            <tr align="center" valign="middle">
                            
                                <td colspan="10" align="left">
                                    <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" id="label_desde_html" runat="server">Desde: </span>
                                    <asp:Label CssClass="gridtextgray" ID="lblDesde" runat="server" Text="Label"></asp:Label>
                                    &nbsp;
                                    <span class="gridtextgray" id="label_hasta_html" runat="server">Hasta: </span>
                                    <asp:Label CssClass="gridtextgray" ID="lblHasta" runat="server" Text="Label"></asp:Label>
                                    
                                    
                                </td>                                
                                <td >
                                    &nbsp;</td>
                                <td >
                                    &nbsp;</td>

                            </tr>
                            
                             <tr align="center" valign="middle">
                                 <td style="width:50px; border-top: 1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px; display:none" 
                                     align="right">
                                    <asp:Label ID="Label6" runat="server" CssClass="gridtext" AssociatedControlID="cbxTipoFormatoGGPP" Width="50px">Formato</asp:Label>
                                 </td>
                                 <td align="left" style="width:230px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px; display:none">
                                     <telerik:RadComboBox ID="cbxTipoFormatoGGPP" Runat="server" 
                                         EmptyMessage="Seleccione" EnableLoadOnDemand="False" 
                                         onitemsrequested="cbxTipoFormatoGGPP_ItemsRequested" Skin="Outlook" 
                                         Width="220px" 
                                         onselectedindexchanged="cbxTipoFormatoGGPP_SelectedIndexChanged">
                                     </telerik:RadComboBox>
                                 </td>
                                 <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</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" EnableLoadOnDemand="False" 
                                         onitemsrequested="cbxMoneda_ItemsRequested" Skin="Outlook" Width="70px">
                                     </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="Label2" runat="server" CssClass="gridtext" AssociatedControlID="cbxAcumulado">Tipo</asp:Label>
                                 </td>
                                 <td align="left" style="width:100px; 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="100px">
                                     </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="cbxTipoCuenta">T.Cuenta</asp:Label>
                                 </td>
                                 <td align="left" style="width:130px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <telerik:RadComboBox ID="cbxTipoCuenta" Runat="server" 
                                         EnableLoadOnDemand="False" onitemsrequested="cbxTipoCuenta_ItemsRequested" 
                                         Skin="Office2007" Width="130px" DropDownWidth="180px">
                                     </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</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" 
                                         EnableLoadOnDemand="False" onitemsrequested="cbxNivelCuentas_ItemsRequested" 
                                         Skin="Outlook" Width="97px" 
                                         onselectedindexchanged="cbxNivelCuentas_SelectedIndexChanged">
                                     </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"
                                         onclick="btnActualizar_Click" Text="Actualizar" Width="80px" />
                                 </td>
                             </tr>
                            
                        </table>
                        <table style="height:15px; width:100%" cellpadding="0" cellspacing="0" border="0">
                            <tr>
                                <td></td>
                            </tr>
                        </table>
                       
                        
                        <table border="0" style="border: #CCCCCC 1px solid; width: 100%">
                            <tr>
                                <td style="text-align: center; height: 21px; padding: 4px;">
                                 <telerik:RadGrid 
                                            HeaderStyle-Height="20px"  
                                            HeaderStyle-Width="85px"                                           
                                            AutoGenerateColumns="False" 
                                            ID="tk_Grid" 
                                            PageSize="150" 
                                            runat="server"
                                            style="margin-top: 0px" 
                                            BorderStyle="None"                                             
                                            onitemdatabound="tk_Grid_ItemDataBound" 
                                            onitemcommand="tk_Grid_ItemCommand" 
                                            onneeddatasource="tk_Grid_NeedDataSource" 
                                            AllowAutomaticDeletes="True" 
                                            onprerender="tk_Grid_PreRender" 
                                            ShowStatusBar="True" 
                                            Skin="Office2007"
                                            Height="500px" Culture="es-ES"
                                           
                                            
                                            >                                                                                                                        
                                        
                                        
                                        <SortingSettings EnableSkinSortStyles="False" />
                                        
                                        
                                        <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true" >
                                            <Pdf PageWidth="480mm" />
                                        </ExportSettings>
                                        <ClientSettings EnableRowHoverStyle="true">
                                            <Selecting AllowRowSelect="True" />
                                            <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true"  FrozenColumnsCount="0" />
                                        </ClientSettings>
                                        
                                        
                                        
                                        
<HeaderStyle Height="20px" Width="85px"></HeaderStyle>

                                        
                                        
                                        
                                       <PagerStyle Mode="NextPrevAndNumeric" PageButtonCount="15" />
                                        
                                        <MasterTableView    CommandItemDisplay="Top" 
                                                            CellSpacing="0" 
                                                            ShowGroupFooter="True" 
                                                            ShowFooter="False" 
                                                            DataKeyNames="NombreTipoCuenta, Apertura, Enero" 
                                                            EditMode="PopUp" 
                                                            cellpadding="0"
                                                            GroupLoadMode="Client" AllowNaturalSort="False"
                                                           
                                                            >  
 <SortExpressions>
            <telerik:GridSortExpression FieldName="Orden" SortOrder="descending" />
        </SortExpressions>                                                                                                   
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

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

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

                                                <%--<telerik:GridBoundColumn Aggregate="none" HeaderStyle-Width="210px" DataField="OrdenFGP" UniqueName="OrdenFGP" Resizable="true"
                                                    HeaderText="OrdenFGP" >
                                                    <HeaderStyle Width="30px" />
                                                    <ItemStyle CssClass="gridtext" />
                                                    <FooterStyle  CssClass="gridtextbold" />                                                    
                                                 </telerik:GridBoundColumn> --%>

                                                 <telerik:GridBoundColumn Aggregate="none" DataField="Orden"
                                                    HeaderText="Orden" FooterText="Total" 
                                                    FooterStyle-Font-Bold="true" 
                                                    Display="False">
                                                    <ItemStyle CssClass="gridtext" />
                                                    <FooterStyle Font-Bold="True" />
                                                 </telerik:GridBoundColumn>                                                                                                                                                     
                                                <telerik:GridBoundColumn Aggregate="none" HeaderStyle-Width="210px" DataField="NombreFormatoGanaciasPerdidas" UniqueName="NombreFormatoGanaciasPerdidas" Resizable="true"
                                                    HeaderText="Descripción" FooterText="Resultado del Ejercicio" FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:g}" FooterStyle-Font-Bold="true">
                                                    <HeaderStyle Width="280px"  />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle  CssClass="gridtextbold" />                                                    
                                                 </telerik:GridBoundColumn> 
                                                
                                                <telerik:GridBoundColumn    DataField="PlanCuentaID"  UniqueName="PlanCuentaID"  HeaderStyle-HorizontalAlign="Right" HeaderText="PlanCuentaID" Visible="false"
                                                                            FooterAggregateFormatString="{0:g}" FooterStyle-Font-Bold="true" Groupable="false">
                                                    <HeaderStyle HorizontalAlign="Right" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn> 
                                                
                                                
                                                <telerik:GridBoundColumn    DataField="CodigoPlanCuenta" HeaderStyle-Width="50px" UniqueName="CodigoPlanCuenta"  HeaderStyle-HorizontalAlign="Right" HeaderText="Codigo" 
                                                                            FooterAggregateFormatString="{0:g}" FooterStyle-Font-Bold="true" Groupable="true" Display="true">
                                                    <HeaderStyle HorizontalAlign="Right" Width="75px" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn> 
                                                                                                 
                                                 <telerik:GridBoundColumn Aggregate="none" HeaderStyle-Width="160px" DataField="NombrePlanCuenta" UniqueName="NombrePlanCuenta" 
                                                    HeaderText="Plan De Cuenta" FooterText="Total" FooterAggregateFormatString="{0:g}" FooterStyle-Font-Bold="true" Display="true">
                                                     <HeaderStyle Width="350px" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" HorizontalAlign="Left"/>                                                    
                                                 </telerik:GridBoundColumn> 
                                                 
                                                 
                                                 <telerik:GridBoundColumn Aggregate="none" DataField="FormatoGananciaPerdidaID"
                                                    HeaderText="FormatoGGPPID" FooterText="Total" 
                                                    FooterAggregateFormatString="{0:g}" FooterStyle-Font-Bold="true" 
                                                    Display="False">
                                                    <ItemStyle CssClass="gridtext" />
                                                    <FooterStyle Font-Bold="True" />
                                                 </telerik:GridBoundColumn> 
                                                 
                                                 <telerik:GridBoundColumn Aggregate="none" DataField="FormatoBalanceID"
                                                    HeaderText="FormatoBalanceID" FooterText="Total" 
                                                    FooterAggregateFormatString="{0:g}" FooterStyle-Font-Bold="false" 
                                                    Display="False">
                                                    <ItemStyle CssClass="gridtext" />
                                                    <FooterStyle Font-Bold="True" />
                                                 </telerik:GridBoundColumn>
                                                 
                                                  <telerik:GridBoundColumn    DataField="TipoCuentaID" HeaderText="CuentaID" 
                                                    Aggregate="None" HeaderStyle-HorizontalAlign="Right"
                                                                            FooterAggregateFormatString="{0:g}" 
                                                    FooterStyle-Font-Bold="true" Display="False" >
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                          
                                                
                                                <telerik:GridBoundColumn    DataField="Apertura" Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            UniqueName="Apertura" FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true"  >
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Enero" Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            UniqueName="Enero" FooterAggregateFormatString="{0:g}" FooterStyle-Font-Bold="true" >
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Febrero"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>                                                                                                
                                                
                                                <telerik:GridBoundColumn    DataField="Marzo"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                 
                                                 <telerik:GridBoundColumn    DataField="Abril"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Mayo"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Junio"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Julio" Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Agosto"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Septiembre"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Octubre" Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Noviembre" Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Diciembre" Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>
                                                
                                                <telerik:GridBoundColumn    DataField="Cierre"  Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true" Groupable="false">
                                                                             <HeaderStyle HorizontalAlign="Right"  />
                                                                             <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>       
                                                <telerik:GridBoundColumn    DataField="OrdenFGP"  UniqueName="OrdenFGP"  HeaderText="OrdenFGP" Visible="false"
                                                                           >
                                                    <HeaderStyle HorizontalAlign="Right" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>                                                                                                                            
                                                                                                                                                                                                                                             
                                            </Columns>
                                            
                                            <GroupByExpressions >
                                                <%--<telerik:GridGroupByExpression > 
                                                    <GroupByFields >                                                                                                        
                                                        <telerik:GridGroupByField  FieldName="Orden" />                                                        
                                                    </GroupByFields>
                                                    <SelectFields>
                                                        <telerik:GridGroupByField FieldName="Orden" HeaderText="Texto" />
                                                    </SelectFields>                                                   
                                                </telerik:GridGroupByExpression>--%>
                                                <telerik:GridGroupByExpression > 
                                                    <GroupByFields >                                                                                                        
                                                        <telerik:GridGroupByField  FieldName="Orden"  FormatString="{0:g}" />                                                        
                                                    </GroupByFields>
                                                    <SelectFields>
                                                        <telerik:GridGroupByField FieldName="NombreTipoCuenta" HeaderText="Texto" />
                                                    </SelectFields>                                                   
                                                </telerik:GridGroupByExpression>

                                                <telerik:GridGroupByExpression>
                                                    <GroupByFields>                                                        
                                                        <telerik:GridGroupByField FieldName="OrdenFGP" />
                                                    </GroupByFields>
                                                    <SelectFields >
                                                        <telerik:GridGroupByField  FieldName="NombreFormatoBalance" HeaderText="Texto" />
                                                    </SelectFields>
                                                </telerik:GridGroupByExpression>
                                            </GroupByExpressions>
                                            
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>

                                            <GroupHeaderItemStyle HorizontalAlign="Left" CssClass="gridtext" Font-Size="12px" />
                                            
                                           
<PagerStyle PageSizeControlType="RadComboBox"></PagerStyle>

                                           
                                        <CommandItemStyle CssClass="" HorizontalAlign="Right" />
                                        
                                        <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>
                                        
                                           
                                        </MasterTableView>
                                        
                                        
                                        
                                        
                                        
                                        <GroupingSettings ShowUnGroupButton="True" CollapseTooltip="" ExpandTooltip="" 
                                            GroupContinuedFormatString="... Vienen " 
                                            GroupContinuesFormatString="Van.." 
                                             GroupSplitDisplayFormat="{0}/{1}" />
                                        
                                        
                                        <GroupHeaderItemStyle HorizontalAlign="Left" />
                                        
                                    
                               
<FilterMenu EnableImageSprites="False"></FilterMenu>
                                        
                                    
                               
                                    </telerik:RadGrid>
                                  
                                        
                                                                                                        
                                </td>
                                
                            </tr>
                        </table>
                     
                        
                       
                  
            </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>
      
      <asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="True"
        ShowSummary="False" ValidationGroup="Loggin" />
      <asp:ValidationSummary ID="ValidationSummary2" runat="server" ShowMessageBox="True"
        ShowSummary="False" ValidationGroup="CtrlPeriodo" />       
    
    </form>
</body>
</html>
