public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport2 rpt = new CrystalReport2(); rpt.Site = this.Site; return(rpt); }
private void Print_Load(object sender, EventArgs e) { con.Open(); DataTable dt = new DataTable(); cmd1 = new SqlCommand("select * from sales where id ='" + SalesID + "'", con); dr = new SqlDataAdapter(cmd1); dr.Fill(dt); DataTable dt1 = new DataTable(); cmd2 = new SqlCommand("select * from sales_product where sales_id ='" + SalesID + "'", con); dr = new SqlDataAdapter(cmd2); dr.Fill(dt1); con.Close(); CrystalReport2 cr2 = new CrystalReport2(); cr2.Database.Tables["sales"].SetDataSource(dt); cr2.Database.Tables["sales_product"].SetDataSource(dt1); this.crystalReportViewer1.ReportSource = cr2; }