<%@ Page Language="C#" EnableEventValidation="true" AutoEventWireup="true" CodeFile="EstadoCuentaProveedor.aspx.cs" Inherits="EstadoCuentaProveedor" %>
<%@ 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>    
        <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;
            }
            
            .RadPicker_Outlook
            {
	            vertical-align:middle;
            }

            .RadPicker_Outlook
            {
	            vertical-align:middle;
            }

            .RadPicker_Outlook .rcCalPopup
            {
	            background-position:0 0;
            }

            .RadPicker_Outlook .rcCalPopup
            {
	            display:block;
	            overflow:hidden;
	            width:22px;
	            height:22px;
	            background:url('mvwres://Telerik.Web.UI, Version=2009.2.826.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4/Telerik.Web.UI.Skins.Outlook.Calendar.sprite.gif') no-repeat;
	            text-indent:-2222px;
	            text-align:center;
            }

            .RadPicker_Outlook .rcCalPopup
            {
	            background-position:0 0;
            }

            .RadPicker_Outlook .rcCalPopup
            {
	            display:block;
	            overflow:hidden;
	            width:22px;
	            height:22px;
	            background:url('mvwres://Telerik.Web.UI, Version=2009.2.826.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4/Telerik.Web.UI.Skins.Outlook.Calendar.sprite.gif') no-repeat;
	            text-indent:-2222px;
	            text-align:center;
            }

    </style>
    </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" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            
             <telerik:AjaxSetting AjaxControlID="btnBuscar">
                <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" valign="top">
          <table width="100%" cellpadding="0" cellspacing="0" border="0" 
                style=" background-color: #FFFFFF;">
            <tr>
              <td colspan="2" style="height:7px" bgcolor="#FFFFFF"></td>
            </tr>
            <tr>
              <td valign="top" style="height:10px">
              
              <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 POR PROVEEDOR : SALDOS
                        </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>
            <td align="left" valign="bottom" style="height: 5px;">
 <table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr >        
    <td style="width:50%; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;" align="left">                                
        <telerik:RadListBox ID="rlbProveedores" runat="server" Height="200px" Width="650px" CssClass="gridtext" 
        AccessKey="y" AllowDelete="true" SelectionMode="Single" TabIndex="1" Skin="Outlook"
        DataTextField="RazonSocial" DataValueField="EmpresaID">
        <ButtonSettings  ShowDelete="false" />
        
        </telerik:RadListBox>
    </td>
    <td style="width:70px; border-top:1px dotted #3E5729; padding-top:5px; border-bottom:1px dotted #3E5729; padding-bottom:5px;" align="center">
         
         
        <table width="70%" 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="68px" EmptyMessage="Plan de Cuenta">
                    </telerik:RadTextBox>
                </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="68px" EmptyMessage="Plan de Cuenta">
                    </telerik:RadTextBox>
                </td>
            </tr>
            <tr>
                <td align="right" style=" border-bottom: 1px dotted #3E5729; padding-top:5px; padding-bottom: 5px;">Desde&nbsp</td>
                <td align="left" style=" border-bottom: 1px dotted #3E5729; padding-top:5px; padding-bottom: 5px;" >
                    <telerik:RadDatePicker ID="txtDesde" runat="server" Skin="Outlook" Width="100px">
                        <Calendar runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x" Skin="Outlook">
                        </Calendar>
                        <DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
                    </telerik:RadDatePicker>
                </td>
                <td align="right"style=" border-bottom: 1px dotted #3E5729; padding-top:5px; padding-bottom: 5px;"> Hasta&nbsp&nbsp;</td>
                <td align="left" style=" border-bottom: 1px dotted #3E5729; padding-top:5px; padding-bottom: 5px;">
                    <telerik:RadDatePicker ID="txtHasta" runat="server" Skin="Outlook" Width="100px">
                        <Calendar runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x" Skin="Outlook">
                        </Calendar>
                        <DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
                    </telerik:RadDatePicker>
                </td>
            </tr>
            <tr>
                <td></td>
                <td align="left" style="padding-top: 5px; padding-bottom: 5px;">
                    <asp:Button ID="btnBuscar" Text="Buscar" runat="server" CssClass="Button" onclick="btnBuscar_Click" /></td>
                <td >
                </td>
                <td align="left" style="padding-top: 5px; padding-bottom: 5px;"> </td>
            </tr>
        </table>
    </td>
</tr>
</table>                    
            </td>
        </tr>
        
        <tr>
            <td align="left" class="style1" valign="bottom" style="height: 5px;">
                    
                &nbsp;</td>
        </tr>
        
         <tr align="center" valign="middle">
        
        <tr>
            <td align="center">
                
                         
                        <table border="0" style="border:#CCCCCC 1px solid; width: 100%">
                            <tr>
                                <td style="text-align: center; height: 21px; padding: 4px;">
                                                                    
                                 <telerik:RadGrid                                              
                                            AutoGenerateColumns="False" 
                                            ID="tk_Grid" 
                                            AllowPaging="True" 
                                            PageSize="400" 
                                            Height="480px"
                                            runat="server" 
                                            GridLines="None"
                                            style="margin-top: 0px" 
                                            BorderStyle="None"
                                            AllowFilteringByColumn="false" 
                                        onneeddatasource="tk_Grid_NeedDataSource" 
                                        onitemdatabound="tk_Grid_ItemDataBound" 
                                        Skin="Office2007" 
                                        onitemcommand="tk_Grid_ItemCommand"
                                            >    
                                            
                                        <AlternatingItemStyle HorizontalAlign="Center" />
                                                                                                                                                                
                                        <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 CommandItemDisplay="Top" CellSpacing="0" ShowGroupFooter="true" ShowFooter="true" AllowMultiColumnSorting="true" GroupLoadMode="Client">                                                            
                                        
                                        <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>
                                        
                                        <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="83px" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" Visible = "false"
                                                    HeaderText="NombrePlanCuenta" FooterAggregateFormatString="{0:g}" >

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

                                                    <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="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="Origen"  HeaderStyle-Width="120px" FilterControlWidth="100%" ShowFilterIcon="false" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                                    HeaderText="O/V" FooterAggregateFormatString="{0:g}" >

<HeaderStyle Width="53px"></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="80px" />
                                                    <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>
              
              
              </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>
