public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { WagesCashWorkBreakDownRPT rpt = new WagesCashWorkBreakDownRPT(); rpt.Site = this.Site; return(rpt); }
private void btnCashBreakDown_Click(object sender, EventArgs e) { String strCrop = "%"; String strAllDiv = "%"; DateTime dtFrom = dtpFromDate.Value.Date; DateTime dtTo = dtpToDate.Value.Date; //if (chkAllCrops.Checked) // strCrop = "%"; //else // strCrop = cmbCropType.SelectedValue.ToString(); if (chkDivision.Checked) { strAllDiv = "%"; } else { strAllDiv = cmbDivision.SelectedValue.ToString(); } DataSet dsWagesRPT = myWage.GetCashWorkBreakDown(strAllDiv, strCrop, dtFrom, dtTo); if (dsWagesRPT.Tables[0].Rows.Count > 0) { dsWagesRPT.WriteXml("CheckrollCashBreakDown.xml"); WagesCashWorkBreakDownRPT myReport1 = new WagesCashWorkBreakDownRPT(); myReport1.SetDataSource(dsWagesRPT); ReportViewer myViewer = new ReportViewer(); myReport1.SetParameterValue("Date", "From:" + dtpFromDate.Value.Date.ToShortDateString() + " To:" + dtpToDate.Value.Date.ToShortDateString()); myReport1.SetParameterValue("Estate", myEstate.ListEstates().Rows[0][0].ToString()); myReport1.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName()); if (chkDivision.Checked) { myReport1.SetParameterValue("Division", "All Division"); } else { myReport1.SetParameterValue("Division", "Division " + strAllDiv); } myReport1.SetParameterValue("Crop Type", "ALL"); myViewer.crystalReportViewer1.ReportSource = myReport1; myViewer.Show(); } }