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