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