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