public virtual ReportDocument CreateReport() { CrystalReport1 report = new CrystalReport1(); report.InitReport += new EventHandler( this.webService.OnInitReport ); return ( report ); }
public virtual ReportDocument CreateReport() { CrystalReport1 report = new CrystalReport1(); report.InitReport += new EventHandler(this.webService.OnInitReport); return(report); }
private void Page_Load(object sender, System.EventArgs e) { string sql; string pers_ncorr, periodo, persona, filtro, peri_sel; string q_ocultar_sin_saldo; pers_ncorr = Request.QueryString["pers_ncorr"]; periodo = Request.QueryString["periodo"]; persona = Request.QueryString["persona"]; filtro = Request.QueryString["filtro"]; q_ocultar_sin_saldo = Request.QueryString["ocultar"]; peri_sel = Request.QueryString["peri_sel"]; //pers_ncorr="18949"; //Periodo="164"; bsolo_pendientes = false; if (q_ocultar_sin_saldo == "S") { bsolo_pendientes = true; } CrystalReport1 reporte = new CrystalReport1(); sql = generar_sql_detalles(pers_ncorr, filtro, peri_sel); oleDbDataAdapter1.SelectCommand.CommandText = sql; oleDbDataAdapter1.Fill(dataSet11); sql = generar_sql_datos_alumno(pers_ncorr, periodo, persona, peri_sel); oleDbDataAdapter2.SelectCommand.CommandText = sql; oleDbDataAdapter2.Fill(dataSet11); sql = generar_sql_credito(pers_ncorr); oleDbDataAdapter3.SelectCommand.CommandText = sql; oleDbDataAdapter3.Fill(dataSet11); sql = generar_sql_comentarios(pers_ncorr); oleDbDataAdapter4.SelectCommand.CommandText = sql; oleDbDataAdapter4.Fill(dataSet11); reporte.SetDataSource(dataSet11); CrystalReportViewer1.ReportSource = reporte; ExportarPDF(reporte); }
private void Page_Load(object sender, System.EventArgs e) { string sql; string pers_ncorr,periodo,persona,filtro,peri_sel; string q_ocultar_sin_saldo; pers_ncorr = Request.QueryString["pers_ncorr"]; periodo = Request.QueryString["periodo"]; persona = Request.QueryString["persona"]; filtro = Request.QueryString["filtro"]; q_ocultar_sin_saldo = Request.QueryString["ocultar"]; peri_sel = Request.QueryString["peri_sel"]; //pers_ncorr="18949"; //Periodo="164"; bsolo_pendientes = false; if (q_ocultar_sin_saldo == "S") bsolo_pendientes = true; CrystalReport1 reporte = new CrystalReport1(); sql = generar_sql_detalles(pers_ncorr,filtro,peri_sel); oleDbDataAdapter1.SelectCommand.CommandText = sql; oleDbDataAdapter1.Fill(dataSet11); sql = generar_sql_datos_alumno(pers_ncorr,periodo,persona,peri_sel); oleDbDataAdapter2.SelectCommand.CommandText = sql; oleDbDataAdapter2.Fill(dataSet11); sql = generar_sql_credito(pers_ncorr); oleDbDataAdapter3.SelectCommand.CommandText = sql; oleDbDataAdapter3.Fill(dataSet11); sql = generar_sql_comentarios(pers_ncorr); oleDbDataAdapter4.SelectCommand.CommandText = sql; oleDbDataAdapter4.Fill(dataSet11); reporte.SetDataSource(dataSet11); CrystalReportViewer1.ReportSource = reporte; ExportarPDF(reporte); }
public virtual ReportDocument CreateReport() { CrystalReport1 rpt = new CrystalReport1(); rpt.Site = this.Site; return rpt; }