public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SkippedDeductionsRPT rpt = new SkippedDeductionsRPT(); rpt.Site = this.Site; return(rpt); }
private void btnSkippedDeductions_Click(object sender, EventArgs e) { string strRoute = "%"; if (chkRoute.Checked) { strRoute = "%"; } else { strRoute = cmbRoute.SelectedValue.ToString(); } DataTable dataSetReport = new DataTable(); dataSetReport.TableName = "SkippedDeductionsDetails"; BoughtLeafBusinessLayer.MothlyPaymentSummary myMonthlySummary = new BoughtLeafBusinessLayer.MothlyPaymentSummary(); string supCode = string.Empty; if (chkSupplier.Checked == true) { supCode = "%"; } else { supCode = cmbSupplier.SelectedValue.ToString(); } dataSetReport = myMonthlySummary.getSkippedDeductions(strRoute, Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())).Tables[0]; dataSetReport.WriteXml("SkippedDeductionsDetails.xml"); SkippedDeductionsRPT myReport = new SkippedDeductionsRPT(); myReport.SetDataSource(dataSetReport); ReportViewer rptViewer = new ReportViewer(); myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName()); myReport.SetParameterValue("Year", cmbYear.Text); myReport.SetParameterValue("Month", cmbMonth.SelectedValue.ToString()); if (chkRoute.Checked == true) { myReport.SetParameterValue("Route", "All Routes"); } else { myReport.SetParameterValue("Route", cmbRoute.Text); } rptViewer.crystalReportViewer1.ReportSource = myReport; rptViewer.Show(); }