public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
OvertimeDetailsRPT rpt = new OvertimeDetailsRPT();
rpt.Site = this.Site;
return(rpt);
}
private void btnOverTime_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
String strDivision = cmbDivision.SelectedValue.ToString();
String strCropTypeOt = "%";
String strParamCrop = "All";
if (chkAllCropsOt.Checked)
{
strCropTypeOt = "%";
strParamCrop = "All";
}
else
{
strCropTypeOt = cmbCropTypeOt.SelectedValue.ToString();
strParamCrop = FTSSettings.getNameByCode("CropType", Convert.ToInt32(cmbCropTypeOt.SelectedValue.ToString()));
}
if (chkDivision.Checked)
{
strDivision = "%";
}
else
{
strDivision = cmbDivision.SelectedValue.ToString();
}
DateTime Fromdate = Convert.ToDateTime(dtpFromDate.Value.Date.ToShortDateString());
DateTime Todate = Convert.ToDateTime(dtpToDate.Value.Date.ToShortDateString());
ds = myReports.GetOvertimeDetails(strDivision, Fromdate, Todate, strCropTypeOt);
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("OvertimeDetails.xml");
OvertimeDetailsRPT myReportViewe = new OvertimeDetailsRPT();
myReportViewe.SetDataSource(ds);
myReportViewe.SetParameterValue("Estate", "Estate:" + myEstate.ListEstates().Rows[0][0].ToString() + " / DivisionID:" + cmbDivision.SelectedValue.ToString());
myReportViewe.SetParameterValue("Date", "From: " + Fromdate.ToShortDateString() + " To: " + Todate.ToShortDateString());
myReportViewe.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myReportViewe.SetParameterValue("crop", strParamCrop);
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myReportViewe;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Print", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
