public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport3 rpt = new CrystalReport3(); rpt.Site = this.Site; return(rpt); }
private void button3_Click(object sender, EventArgs e) { MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=kanuudb"); // MySqlDataAdapter ada = new MySqlDataAdapter("SELECT * FROM emp_reg ,salary,loan,sal_work_hour WHERE emp_reg.empid = salary.empid and emp_reg.empid = loan.empid AND emp_reg.empid=sal_work_hour.empid and salary.empid = '"+txtempid.Text+"' AND sal_work_hour.date BETWEEN '"+ bunifuDatepicker1.Value.Date.ToString("yyyy-MM-dd") + "' and '" + bunifuDatepicker2.Value.Date.ToString("yyyy-MM-dd") + "'", con); MySqlDataAdapter ada = new MySqlDataAdapter("SELECT * FROM emp_reg, salary, sal_work_hour WHERE emp_reg.empid = salary.empid and emp_reg.empid=sal_work_hour.empid and salary.empid = '" + txtempid.Text + "' AND sal_work_hour.date BETWEEN '" + bunifuDatepicker1.Value.Date.ToString("yyyy-MM-dd") + "' and '" + bunifuDatepicker2.Value.Date.ToString("yyyy-MM-dd") + "'", con); DataSet dat = new DataSet(); ada.Fill(dat, "salary"); crystalReportViewer1.Visible = true; CrystalReport3 cry = new CrystalReport3(); cry.SetDataSource(dat); crystalReportViewer1.ReportSource = cry; button6.Visible = true; }