<%@ Page Language="C#" EnableEventValidation="false" AutoEventWireup="true" CodeFile="EstadoCuenta.aspx.cs" Inherits="EstadoCuenta" %>

<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
    Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<%@ 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 DE CUENTA </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>    
        
    </head>
<body>
    <form id="form2" runat="server" method="post" defaultfocus="txtUsuario">
    <telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server">
    </telerik:RadStyleSheetManager>
    <asp:ScriptManager ID="ScriptManager1" runat="server" />
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
            <script type="text/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>
           </telerik:RadCodeBlock>
   
     <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" />
                    <telerik:AjaxUpdatedControl ControlID="lblTipo" UpdatePanelRenderMode="Inline" />
                </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">                            
                           ESTADO DE CUENTA : <asp:Label ID="lblTipo" runat="server" Text="Label"></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="img15" runat="server" src="images/Back.png" border="0" />                                            
                            </a>                            
                        </td>
                        <td background="images/LineGray.png" style="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>
        </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:70px; 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" >Cuenta Inicio&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:RadTextBox ID="txtPlanCuenta" runat="server" Width="50px" 
                                        EmptyMessage="Plan de Cuenta">
                                        </telerik:RadTextBox>
                                        
                                        <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="txtPlanCuenta"
                                        ErrorMessage="*" ValidationExpression="^[0-9]{0,}$" SetFocusOnError="True">
                                        </asp:RegularExpressionValidator>
                                                        
                                                        
                                     </td>
                                 <td style="width:70px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;" align="right">
                                     <asp:Label ID="Label3" runat="server" CssClass="gridtext" >Cuenta Fin&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:RadTextBox ID="txtPlanCuentaFin" runat="server" Width="50px" 
                                            EmptyMessage="Plan de Cuenta">
                                        </telerik:RadTextBox>
                                        
                                        <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtPlanCuentaFin"
                                        ErrorMessage="*" ValidationExpression="^[0-9]{0,}$" SetFocusOnError="True">
                                        </asp:RegularExpressionValidator>
                                                        
                                     </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="Label4" runat="server" CssClass="gridtext" >Desde&nbsp</asp:Label>
                                    </td>
                                 <td align="left" style="width:57px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                    <telerik:RadDatePicker ID="txtDesde" runat="server" Skin="Outlook">
                                        <Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x" 
                                            Skin="Outlook"></Calendar>

<DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
                </telerik:RadDatePicker>
                                </td>
                                 <td style="width:10px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <asp:Label ID="Label2" runat="server" CssClass="gridtext" >Hasta&nbsp</asp:Label>&nbsp;</td>
                                     <td align="left" style="width:57px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                <telerik:RadDatePicker ID="txtHasta" runat="server" Skin="Outlook">
<Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x" 
                        Skin="Outlook"></Calendar>

<DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
                </telerik:RadDatePicker>

        
                                </td>
                                <td style="width:10px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <asp:Label ID="Label5" runat="server" CssClass="gridtext" >Tipo&nbsp</asp:Label>&nbsp;</td>                                
                                <td align="left" style="border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;">
                                     <telerik:RadComboBox ID="cbxTipo" Runat="server" Width="132px" 
                                         Skin="Outlook">
                                         <Items>
                                             <telerik:RadComboBoxItem runat="server" Selected="True" Text="Historico" Value="1" />
                                             <telerik:RadComboBoxItem runat="server"  Text="Saldos" Value="2" />
                                         </Items>
                                     </telerik:RadComboBox>
                                 </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%">
                            <tr>
                                <td style="text-align: center; height: 21px; padding: 4px;">
                                  <div class="LineaExportar">
                                            <table  style="width:100%" cellpadding="0" cellspacing="0" border="0" >
                                            <tr>
                                            <td style="width:50%; text-align:left; padding:2px">
                                       
                                            </td>
                                            <td style="width:50%" align="right">
                                            <asp:ImageButton runat="server" ID="ExcelExport" OnClick="Exportar_Data" ImageUrl="~/images/page_excel.png" CommandName="ExportExcel" AlternateText="Excel" ToolTip="Excel" /> 
                                            <asp:ImageButton runat="server" ID="PDFExport" OnClick="Exportar_Data" ImageUrl="~/images/page_acrobat.png" CommandName="ExportPDF" AlternateText="Pdf" ToolTip="Pdf" />
                                            <asp:ImageButton runat="server" ID="WordExport" OnClick="Exportar_Data" ImageUrl="~/images/page_word.png" CommandName="ExportWord" AlternateText="Word" ToolTip="Word" />
                                            <asp:ImageButton runat="server" ID="CSVExport" OnClick="Exportar_Data" ImageUrl="~/images/page_csv.png" CommandName="ExportCSV" AlternateText="CSV" ToolTip="CSV" />
                                            <asp:ImageButton runat="server" ID="Print" OnClick="Exportar_Data" ImageUrl="~/images/printer.png" CommandName="Print" AlternateText="Print" ToolTip="Imprimir" />
                                            </td>
                                            </tr>
                                            </table>
                                  
                                  </div>
                                    <telerik:RadGrid AutoGenerateColumns="False" ID="tk_Grid" AllowPaging="True" PageSize="300"
                                        Height="480px" runat="server" GridLines="None" AllowFilteringByColumn="True"
                                        OnNeedDataSource="tk_Grid_NeedDataSource" OnItemDataBound="tk_Grid_ItemDataBound"
                                        Skin="Office2007" OnItemCommand="tk_Grid_ItemCommand">
                                        <AlternatingItemStyle HorizontalAlign="Center" />
                                        <%--    <HeaderStyle HorizontalAlign="Center" ForeColor="White" />
                                            <EditItemStyle BackColor="#EAFFEA" />
                                            <ActiveItemStyle BackColor="#333300" />--%>
                                        <PagerStyle Mode="NextPrevAndNumeric" PageButtonCount="15" />
                                        <HeaderContextMenu Skin="Inox">
                                            <CollapseAnimation Duration="200" Type="OutQuint" />
                                        </HeaderContextMenu>
                                        <ExportSettings ExportOnlyData="true" OpenInNewWindow="true" IgnorePaging="True">
                                            <Pdf PageWidth="360mm" />
                                            <Excel Format="Html" />
                                        </ExportSettings>
                                        <GroupingSettings CaseSensitive="False" />
                                        <MasterTableView CellSpacing="0" ShowGroupFooter="true" ShowFooter="true" AllowMultiColumnSorting="true"
                                            GroupLoadMode="Client" NoMasterRecordsText="No hay Registro">
                                            <CommandItemStyle CssClass="" HorizontalAlign="Right" />
                                            <Columns>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="BEPlanDeCuentas.CodigoPlanCuenta"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" Visible="false" HeaderText="CodigoPlanCuenta"
                                                    FooterAggregateFormatString="{0:g}" HeaderStyle-Width="57px" AutoPostBackOnFilter="true"
                                                    CurrentFilterFunction="StartsWith">
                                                    <HeaderStyle Width="57px"></HeaderStyle>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="BEPlanDeCuentas.NombrePlanCuenta"
                                                    HeaderStyle-Width="203px" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains"
                                                    AutoPostBackOnFilter="true" Visible="false" HeaderText="NombrePlanCuenta" FooterAggregateFormatString="{0:g}">
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="BEPlanDeCuentas.CodigoPlanCuenta"
                                                    HeaderStyle-Width="123px" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="Plan de Cuenta" FooterAggregateFormatString="{0:g}">
                                                    <HeaderStyle Width="123px"></HeaderStyle>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="RazonSocial" HeaderStyle-Width="123px"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains"
                                                    AutoPostBackOnFilter="true" Visible="false" HeaderText="Razon Social" FooterAggregateFormatString="{0:g}">
                                                    <HeaderStyle Width="123px"></HeaderStyle>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="PeriodoID" HeaderStyle-Width="53px"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains"
                                                    AutoPostBackOnFilter="true" HeaderText="Periodo" FooterAggregateFormatString="{0:g}">
                                                    <HeaderStyle Width="53px"></HeaderStyle>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="Origen" HeaderStyle-Width="53px"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains"
                                                    AutoPostBackOnFilter="true" HeaderText="Origen" FooterAggregateFormatString="{0:g}">
                                                    <HeaderStyle Width="53px"></HeaderStyle>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>

                                                <telerik:GridBoundColumn Aggregate="none" DataField="Comprobante" HeaderStyle-Width="83px"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains"
                                                    AutoPostBackOnFilter="true" Visible="true" HeaderText="Comprobante" FooterAggregateFormatString="{0:g}">
                                                    <HeaderStyle Width="90px" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="Dia" HeaderStyle-Width="73px"
                                                    DataType="System.DateTime" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains"
                                                    AutoPostBackOnFilter="true" DataFormatString="{0:dd/MM/yyyy}" HeaderText="Fecha"
                                                    FooterAggregateFormatString="{0:g}">
                                                    <HeaderStyle Width="73px"></HeaderStyle>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="CodigoSunat" FilterControlWidth="100%"
                                                    ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    Visible="true" HeaderText="Tipo Doc.">
                                                    <HeaderStyle Width="50px" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn Aggregate="none" DataField="NumeroDocumento" HeaderStyle-Width="100px"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="Nro.Documento" FooterAggregateFormatString="{0:g}"
                                                    DataType="System.Char" HtmlEncode="True">
                                                    <HeaderStyle Width="100px"></HeaderStyle>
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Left" />
                                                    <FooterStyle Font-Bold="True" />
                                                </telerik:GridBoundColumn>
                                                <telerik:GridNumericColumn Aggregate="Sum" DataField="DebeSoles" DataType="System.Decimal"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="DebeSoles" HeaderStyle-HorizontalAlign="Right"
                                                    FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}">
                                                    <HeaderStyle HorizontalAlign="Center" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                </telerik:GridNumericColumn>
                                                <telerik:GridNumericColumn Aggregate="Sum" DataField="HaberSoles" DataType="System.Decimal"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="HaberSoles" HeaderStyle-HorizontalAlign="Right"
                                                    FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}">
                                                    <HeaderStyle HorizontalAlign="Center" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                </telerik:GridNumericColumn>
                                                <telerik:GridNumericColumn Aggregate="Sum" DataField="SaldoSoles" DataType="System.Decimal"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="SaldoSoles" HeaderStyle-HorizontalAlign="Right"
                                                    FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}">
                                                    <HeaderStyle HorizontalAlign="Center" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                </telerik:GridNumericColumn>
                                                <telerik:GridNumericColumn Aggregate="Sum" DataField="DebeDolares" DataType="System.Decimal"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="DebeDolares" HeaderStyle-HorizontalAlign="Right"
                                                    FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}">
                                                    <HeaderStyle HorizontalAlign="Center" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                </telerik:GridNumericColumn>
                                                <telerik:GridNumericColumn Aggregate="Sum" DataField="HaberDolares" DataType="System.Decimal"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="HaberDolares" HeaderStyle-HorizontalAlign="Right"
                                                    FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}">
                                                    <HeaderStyle HorizontalAlign="Center" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                </telerik:GridNumericColumn>
                                                <telerik:GridNumericColumn Aggregate="Sum" DataField="SaldoDolares" DataType="System.Decimal"
                                                    FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="StartsWith"
                                                    AutoPostBackOnFilter="true" HeaderText="SaldoDolares" HeaderStyle-HorizontalAlign="Right"
                                                    FooterStyle-HorizontalAlign="Right" FooterAggregateFormatString="{0:N2}" DataFormatString="{0:N2}">
                                                    <HeaderStyle HorizontalAlign="Center" />
                                                    <ItemStyle CssClass="gridtext" HorizontalAlign="Right" />
                                                    <FooterStyle Font-Bold="True" CssClass="gridtext" />
                                                </telerik:GridNumericColumn>
                                            </Columns>
                                            <GroupByExpressions>
                                                <telerik:GridGroupByExpression>
                                                    <GroupByFields>
                                                        <telerik:GridGroupByField FieldName="BEPlanDeCuentas.CodigoPlanCuenta" />
                                                    </GroupByFields>
                                                    <SelectFields>
                                                        <telerik:GridGroupByField FieldName="BEPlanDeCuentas.NombrePlanCuenta" HeaderText="Grupo" />
                                                    </SelectFields>
                                                </telerik:GridGroupByExpression>
                                                <telerik:GridGroupByExpression>
                                                    <GroupByFields>
                                                        <telerik:GridGroupByField FieldName="RazonSocial" />
                                                    </GroupByFields>
                                                    <SelectFields>
                                                        <telerik:GridGroupByField FieldName="RazonSocial" HeaderText="Grupo" />
                                                    </SelectFields>
                                                </telerik:GridGroupByExpression>
                                            </GroupByExpressions>
                                        </MasterTableView>
                                        <GroupHeaderItemStyle HorizontalAlign="Left" Font-Strikeout="False" />
                                        <GroupingSettings ShowUnGroupButton="True" CollapseTooltip="" ExpandTooltip="" GroupContinuedFormatString="... Vienen"
                                            GroupContinuesFormatString="Van..." GroupSplitDisplayFormat="" />
                                        <GroupHeaderItemStyle HorizontalAlign="Left" />
                                        <ClientSettings EnableRowHoverStyle="true">
                                            <Selecting AllowRowSelect="True" />
                                            <Scrolling AllowScroll="True" UseStaticHeaders="true" />
                                        </ClientSettings>
                                    </telerik:RadGrid>
                                </td>
                                
                            </tr>
                        </table>
                   
            </td>
        </tr>
    </table>
              

                  <CR:CrystalReportViewer ID="CRV_1" runat="server" AutoDataBind="true" 
                      ReuseParameterValuesOnRefresh="True" ToolPanelView="ParameterPanel" />
              
              </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>
