/* * * private string Crear_Consulta_Listado_Letras(string envio, string periodo) * { * string sql; * sql = "select a.envi_ncorr, b.ting_ccod, b.ding_ndocto as c_ding_ndocto, b.ingr_ncorr ,b.ding_ndocto, \n"; * sql = sql + " c.ding_mdocto,c.ding_mdetalle, a.envi_fenvio, d.ingr_fpago, convert(varchar,d.ingr_fpago,103) as ingr_fpago, \n"; * sql = sql + " c.ding_fdocto, c1.edin_ccod, c1.edin_tdesc, cast(e.pers_nrut as varchar) + '-' + e.pers_xdv as rut_alumno, \n"; * sql = sql + " protic.obtener_nombre(f.pers_ncorr,'n') as nombre_apoderado, \n"; * sql = sql + " (select ccte_tdesc from cuentas_corrientes where ccte_ccod = a.ccte_ccod) ccte_tdesc, (select inen_tdesc from instituciones_envio where inen_ccod = a.inen_ccod) as inen_tdesc, cast(f.pers_tnombre as varchar) + ' ' + f.pers_tape_paterno as nombre_apoderado \n"; * sql = sql + " from envios a,detalle_envios b,detalle_ingresos c,estados_detalle_ingresos c1, \n"; * sql = sql + " ingresos d,personas e,personas f \n"; * sql = sql + " where a.envi_ncorr = b.envi_ncorr \n"; * sql = sql + " and b.ting_ccod = c.ting_ccod \n"; * sql = sql + " and b.ding_ndocto = c.ding_ndocto \n"; * sql = sql + " and b.ingr_ncorr = c.ingr_ncorr \n"; * sql = sql + " and b.edin_ccod = c1.edin_ccod \n"; * sql = sql + " and c.ingr_ncorr = d.ingr_ncorr \n"; * sql = sql + " and d.pers_ncorr = e.pers_ncorr \n"; * sql = sql + " and c.PERS_NCORR_CODEUDOR *= f.pers_ncorr \n"; * sql = sql + " and c.DING_NCORRELATIVO = 1 \n"; * sql = sql + " and cast(a.envi_ncorr as varchar) ='" + envio + "'"; * return (sql); * } * */ private void Page_Load(object sender, System.EventArgs e) { string sql, envio, periodo; periodo = Request.QueryString["periodo"]; envio = Request.QueryString["folio_envio"]; //envio="97"; //periodo="300"; CrystalReport1 ListadoAgrupado = new CrystalReport1(); sql = Crear_Consulta_Listado_Letras(envio, periodo); Response.Write(sql); //Response.Flush(); oleDbDataAdapter1.SelectCommand.CommandText = sql; oleDbDataAdapter1.Fill(dataSet11); ListadoAgrupado.SetDataSource(dataSet11); CrystalReportViewer1.ReportSource = ListadoAgrupado; ExportarPDF(ListadoAgrupado); }
/* private string Crear_Consulta_Listado_Letras(string envio, string periodo) { string sql; sql = "select a.envi_ncorr, b.ting_ccod, b.ding_ndocto as c_ding_ndocto, b.ingr_ncorr ,b.ding_ndocto, \n"; sql = sql + " c.ding_mdocto,c.ding_mdetalle, a.envi_fenvio, d.ingr_fpago, convert(varchar,d.ingr_fpago,103) as ingr_fpago, \n"; sql = sql + " c.ding_fdocto, c1.edin_ccod, c1.edin_tdesc, cast(e.pers_nrut as varchar) + '-' + e.pers_xdv as rut_alumno, \n"; sql = sql + " protic.obtener_nombre(f.pers_ncorr,'n') as nombre_apoderado, \n"; sql = sql + " (select ccte_tdesc from cuentas_corrientes where ccte_ccod = a.ccte_ccod) ccte_tdesc, (select inen_tdesc from instituciones_envio where inen_ccod = a.inen_ccod) as inen_tdesc, cast(f.pers_tnombre as varchar) + ' ' + f.pers_tape_paterno as nombre_apoderado \n"; sql = sql + " from envios a,detalle_envios b,detalle_ingresos c,estados_detalle_ingresos c1, \n"; sql = sql + " ingresos d,personas e,personas f \n"; sql = sql + " where a.envi_ncorr = b.envi_ncorr \n"; sql = sql + " and b.ting_ccod = c.ting_ccod \n"; sql = sql + " and b.ding_ndocto = c.ding_ndocto \n"; sql = sql + " and b.ingr_ncorr = c.ingr_ncorr \n"; sql = sql + " and b.edin_ccod = c1.edin_ccod \n"; sql = sql + " and c.ingr_ncorr = d.ingr_ncorr \n"; sql = sql + " and d.pers_ncorr = e.pers_ncorr \n"; sql = sql + " and c.PERS_NCORR_CODEUDOR *= f.pers_ncorr \n"; sql = sql + " and c.DING_NCORRELATIVO = 1 \n"; sql = sql + " and cast(a.envi_ncorr as varchar) ='" + envio + "'"; return (sql); } */ private void Page_Load(object sender, System.EventArgs e) { string sql, envio, periodo; periodo = Request.QueryString["periodo"]; envio = Request.QueryString["folio_envio"]; //envio="97"; //periodo="300"; CrystalReport1 ListadoAgrupado = new CrystalReport1(); sql = Crear_Consulta_Listado_Letras(envio,periodo); Response.Write(sql); //Response.Flush(); oleDbDataAdapter1.SelectCommand.CommandText = sql; oleDbDataAdapter1.Fill(dataSet11); ListadoAgrupado.SetDataSource(dataSet11); CrystalReportViewer1.ReportSource = ListadoAgrupado; ExportarPDF(ListadoAgrupado); }
public virtual ReportDocument CreateReport() { CrystalReport1 rpt = new CrystalReport1(); rpt.Site = this.Site; return rpt; }