<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="frm_ReporteConciliacion.aspx.vb" Inherits="SGHweb.frm_ReporteConciliacion" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!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 runat="server">
    <title></title>
</head>

<body>
    <form id="form1" runat="server">
    <div>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
            Font-Size="8pt" InteractiveDeviceInfos="(Colección)" 
            WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="1294px" 
            Height="489px">
            <LocalReport ReportPath="SIG\Reportes\Reporte_conciliacion.rdlc">
                <DataSources>
                    <rsweb:ReportDataSource DataSourceId="SqlDataSource_reporte_conciliacion" 
                        Name="DataSet1" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSource_resumen_conciliacion" 
                        Name="DataSet2" />
                    <rsweb:ReportDataSource DataSourceId="SqlDataSource_usuario_resumen" 
                        Name="DataSet3" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>

        <asp:SqlDataSource ID="SqlDataSource_usuario_resumen" runat="server" 
            SelectCommand="SWP_usuario_by_id" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:QueryStringParameter Name="usuario" QueryStringField="uid" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
      
        <asp:SqlDataSource ID="SqlDataSource_reporte_conciliacion" runat="server" 
         
            SelectCommand="SWP_reporte_conciliazion_by_fechas" 
            SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="1990-01-01" Name="fecha_desde" 
                    QueryStringField="fd" Type="String" />
                <asp:QueryStringParameter DefaultValue="" Name="fecha_hasta" 
                    QueryStringField="fh" Type="String" />
                <asp:QueryStringParameter DefaultValue="" Name="usuario" QueryStringField="uid" 
                    Type="Int32" />
                <asp:QueryStringParameter DefaultValue="-1" Name="pagoid" QueryStringField="pago" 
                    Type="Int32" />
                <asp:QueryStringParameter DefaultValue="-1" Name="tarjetaid" QueryStringField="tarjeta" 
                    Type="Int32" />
                <asp:Parameter DefaultValue="0" Name="EstablecimientoID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    
        <asp:SqlDataSource ID="SqlDataSource_resumen_conciliacion" runat="server" 
        
            SelectCommand="SWP_resumen_conciliazion_by_fechas" 
            SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="1990-01-01" Name="fecha_desde" 
                    QueryStringField="fd" Type="String" />
                <asp:QueryStringParameter DefaultValue="" Name="fecha_hasta" 
                    QueryStringField="fh" Type="String" />
                <asp:QueryStringParameter DefaultValue="" Name="usuario" QueryStringField="uid" 
                    Type="Int32" />
                <asp:QueryStringParameter DefaultValue="-1" Name="pagoid" QueryStringField="pago" 
                    Type="Int32" />
                <asp:QueryStringParameter DefaultValue="-1" Name="tarjetaid" QueryStringField="tarjeta" 
                    Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>
    </div>
    </form>
</body>
</html>
