public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { ReporteDeVenta rpt = new ReporteDeVenta(); rpt.Site = this.Site; return(rpt); }
private void llenareporte() { var da = new SqlDataAdapter(); var ds = new dsTallerCr(); string sqlEmployees = "select * from ventas where idventa=(select max(idventa) from ventas)"; //string sqlProducts = "select * from Products"; //string sqlCustomers = "select * from Customers"; var cmd = new SqlCommand("", Conexion); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlEmployees; da.SelectCommand = cmd; da.Fill(ds.Tables["Ventas"]); //cmd.CommandText = sqlProducts; //da.SelectCommand = cmd; //da.Fill(ds.Tables["Products"]); //cmd.CommandText = sqlCustomers; //da.SelectCommand = cmd; //da.Fill(ds.Tables["Customers"]); var rptPractica61 = new ReporteDeVenta(); rptPractica61.SetDataSource(ds); //rptPractica61.Subreports[0].SetDataSource(ds); this.crystalReportViewer1.ReportSource = rptPractica61; this.crystalReportViewer1.Show(); }