public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EmpWorkHistory rpt = new EmpWorkHistory();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
DateTime dtStartDate, dtEndDate;
String strAllEmp = "%";
dtStartDate = myEmpwork.GetStartDate(int.Parse(cmbYear.Text.ToString()), int.Parse(cmbMonth.SelectedValue.ToString()));
dtEndDate = myEmpwork.GetEndDateOfMonth(dtStartDate);
if (chkAll.Checked)
{
strAllEmp = "%";
}
else
{
strAllEmp = cmbEmpNo.SelectedValue.ToString();
}
dataSetReport = myEmpwork.GetEmpWorkHis(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivisionID.SelectedValue.ToString(), strAllEmp);
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("EmpWorkHistory.xml");
EmpWorkHistory EmpWrkHis = new EmpWorkHistory();
EmpWrkHis.SetDataSource(dataSetReport);
EmpWrkHis.SetParameterValue("Estate", "Estate :" + mydiv.ListEstates().Rows[0][0].ToString());
EmpWrkHis.SetParameterValue("Period", "For the month :" + cmbMonth.Text + " / " + cmbYear.Text);
ReportViewer myRepView = new ReportViewer();
myRepView.crystalReportViewer1.ReportSource = EmpWrkHis;
myRepView.Show();
}
else
{
MessageBox.Show("No Data to Preview");
}
}