public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport2 rpt = new CrystalReport2(); rpt.Site = this.Site; return(rpt); }
private void crystalReportViewer1_Load(object sender, EventArgs e) { label2.Text = Form4.agent; var conStr = "server=localhost;user id=root;password=root;database=insurance"; MySqlConnection cnn = new MySqlConnection(conStr); cnn.Open(); var sql = "select agent_id,commission,ph_id,pol_key from sales where agent_id='" + this.label2.Text + "'"; MySqlDataAdapter dscmd = new MySqlDataAdapter(sql, cnn); cnn.Close(); DataSet2 ds = new DataSet2(); dscmd.Fill(ds, "DataTable1"); CrystalReport2 objRpt = new CrystalReport2(); objRpt.SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = objRpt; cnn.Close(); }