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;
}
