private void cmdDisplay2_Click(object sender, EventArgs e) { try { String strDivisionID = cmbDivision.SelectedValue.ToString(); DataSet dataSetReport = new DataSet(); dataSetReport = myReports.getCheckRollReconcilation2(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), (cmbDivision.SelectedValue.ToString())); dataSetReport.WriteXml("CheckRollReconcilation2.xml"); if (dataSetReport.Tables[0].Rows.Count > 0) { CheckRollReconcilationRPT2 myaclist = new CheckRollReconcilationRPT2(); myaclist.SetDataSource(dataSetReport); ReportViewer myReportViewer = new ReportViewer(); myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName()); myaclist.SetParameterValue("Estate", "Estate :" + myDiv.ListEstates().Rows[0][0].ToString()); myaclist.SetParameterValue("Division Name", myDiv.EstateDivision(strDivisionID).Tables[0].Rows[0][0].ToString()); myaclist.SetParameterValue("Period", "Month of " + cmbMonth.Text + "/" + cmbYear.Text); myReportViewer.crystalReportViewer1.ReportSource = myaclist; myReportViewer.Show(); } else { MessageBox.Show("No Data to Preview..!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CheckRollReconcilationRPT2 rpt = new CheckRollReconcilationRPT2(); rpt.Site = this.Site; return(rpt); }