public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { EmployeeWisePaymentDetailsRPT rpt = new EmployeeWisePaymentDetailsRPT(); rpt.Site = this.Site; return(rpt); }
private void button1_Click(object sender, EventArgs e) { try { String strParamDiv = "All Division"; String strParamEmp = "All Employees"; String strEmployee = "%"; String strDivision = "%"; if (!chkAllDivisions.Checked) { strDivision = cmbDivision.SelectedValue.ToString(); strParamDiv = cmbDivision.SelectedValue.ToString(); } if (!chkAllEmp.Checked) { strEmployee = cmbEmpNo.SelectedValue.ToString(); strParamEmp = cmbEmpNo.SelectedValue.ToString(); } DataSet ds = new DataSet(); //dt = myRep.GetAmalgamation(cmbYear.Text, month); ds = myReports.PaymentDetailsSummaryEmpwise(strDivision, dtpFrom.Value.Date, dtpTo.Value.Date, strEmployee); if (ds.Tables[0].Rows.Count > 0) { ds.WriteXml("PaymentDetailsSummaryEmpwise.xml"); //PaymentDetailsSummaryEmpRPTrpt myReport = new PaymentDetailsSummaryEmpRPTrpt(); EmployeeWisePaymentDetailsRPT myReport = new EmployeeWisePaymentDetailsRPT(); myReport.SetDataSource(ds); ReportViewer myViewer = new ReportViewer(); myReport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName()); if (chkAllDivisions.Checked) { myReport.SetParameterValue("Estate", "Estate :" + myDiv.ListEstates().Rows[0][0].ToString() + " - Division:" + strParamDiv); } else { myReport.SetParameterValue("Estate", "Estate :" + myDiv.ListEstates().Rows[0][0].ToString() + " - Division:" + myDiv.GetDivisionNameByID(strParamDiv)); } myReport.SetParameterValue("Period", "From:" + dtpFrom.Value.Date.ToShortDateString() + " To:" + dtpTo.Value.Date.ToShortDateString()); myViewer.crystalReportViewer1.ReportSource = myReport; myViewer.Show(); } else { MessageBox.Show("No Data Preview..!"); } } catch (Exception ex) { MessageBox.Show("Error Occurred..!" + ex.Message); } }