public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport10 rpt = new CrystalReport10(); rpt.Site = this.Site; return(rpt); }
private void Form33_Load(object sender, EventArgs e) { con = new MySqlConnection("server=localhost;username=root;pwd=niku2912;database=canteen"); con.Open(); // cmd = new MySqlCommand("select * from purchase_new", con); da = new MySqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); // da.Fill(ds); cmd = new MySqlCommand("select raw_material.prod_code,raw_material.Prod_name, raw_material.prod_type, stock.total_qty from stock,raw_material where stock.prod_code=raw_material.prod_code and stock.total_qty<=5", con); da = new MySqlDataAdapter(cmd); da.Fill(ds); CrystalReport10 myreport = new CrystalReport10(); myreport.SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = myreport; crystalReportViewer1.Show(); }