public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SalesForItems rpt = new SalesForItems(); rpt.Site = this.Site; return(rpt); }
private void SalesProducts_Load(object sender, EventArgs e) { try { SqlConnection sqlcon = new SqlConnection(conn); sqlcon.Open(); string query = @"select * from SoldItems where BilledDate >= '" + SD + "' and BilledDate <= '" + ED + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon); DataSet ds = new DataSet(); sda.Fill(ds, "SoldItems"); SalesForItems cr1 = new SalesForItems(); cr1.SetDataSource(ds); crystalReportViewer1.ReportSource = cr1; crystalReportViewer1.Refresh(); } catch (Exception ex) { MessageBox.Show(string.Format("An error occurred: {0}", ex.Message)); } }