private void btnShow_Click(object sender, EventArgs e) { try { DateTime UpToDate = Convert.ToDateTime(dateTimePicker1.Text); MCKJ.Reports.Accounts.BalanceSummary.frmReportViewer frm = new frmReportViewer(); MCKJ.Reports.Accounts.BalanceSummary.rptBalanceSummary rpt = new MCKJ.Reports.Accounts.BalanceSummary.rptBalanceSummary(); DataTable dt = DBLayer.getTrialBalance(UpToDate); for (int i = dt.Rows.Count; i > 0; i--) { double balance = Convert.ToDouble(dt.Rows[i - 1].ItemArray.GetValue(4).ToString()); if (balance == 0) { dt.Rows.RemoveAt(i - 1); } } rpt.SetDataSource(dt); frm.crystalReportViewer1.ReportSource = rpt; rpt.SetParameterValue(0, UpToDate); frm.Show(); } catch (FormatException) { MessageBox.Show("Please enter a valid Date!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } catch (Exception ex) { MessageBox.Show("An unknown error occured!\n\nError Description: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }