private void btnPrint_Click(object sender, EventArgs e) { String strDivision = "%"; DataTable dsDivisionReport = new DataTable(); //dsDivisionReport = myEmployeeDeduction.GetMonthPRINorms(cmbDivision.SelectedValue.ToString(), new DateTime(dateTimePicker1.Value.Date.Year, dateTimePicker1.Value.Date.Month, 1), new DateTime(dateTimePicker1.Value.Date.Year, dateTimePicker1.Value.Date.Month, 1).AddMonths(1).AddDays(-1)).Tables[0]; dsDivisionReport = DHarvest.GetSundryAreaCovered(dateTimePicker1.Value.Date, cmbDivision.SelectedValue.ToString()).Tables[0]; if (dsDivisionReport.Rows.Count > 0) { dsDivisionReport.WriteXml("SundryAreaCovered.xml"); SundryAreaCoveredRPT objReport = new SundryAreaCoveredRPT(); objReport.SetDataSource(dsDivisionReport); ReportViewerForm objReportViewer = new ReportViewerForm(); objReport.SetParameterValue("Estate", myDivi.ListEstates().Rows[0][0].ToString()); objReport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName()); objReport.SetParameterValue("Division", cmbDivision.SelectedValue.ToString()); objReport.SetParameterValue("Period", dateTimePicker1.Value.Date.ToShortDateString()); objReportViewer.crystalReportViewer1.ReportSource = objReport; objReportViewer.Show(); } else { MessageBox.Show("No Data To Preview."); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SundryAreaCoveredRPT rpt = new SundryAreaCoveredRPT(); rpt.Site = this.Site; return(rpt); }