//Load Report private void LoadResignMember() { ResignMemberReport.Reset(); DataTable dt = getResignData(); ReportDataSource masterData = new ReportDataSource("AnnualStatement", dt); ResignMemberReport.LocalReport.DataSources.Add(masterData); ResignMemberReport.LocalReport.ReportEmbeddedResource = "Nube.Reports.MonthlyStatement.rdlc"; // ResignMemberReport.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(Details); ReportParameter[] rp = new ReportParameter[3]; rp[0] = new ReportParameter("BranchName", cmbNubeBranch.SelectedValue.ToString()); rp[1] = new ReportParameter("Month", String.Format("{0:MMM-yyyy}", dtpDate.SelectedDate.Value)); rp[2] = new ReportParameter("Title", "Resigned Member"); ResignMemberReport.LocalReport.SetParameters(rp); ResignMemberReport.RefreshReport(); }
private void LoadResignMember() { ResignMemberReport.Reset(); DataTable dt = getResignData(); if (dt.Rows.Count > 0) { ReportDataSource masterData = new ReportDataSource("BranchAdviceList", dt); ResignMemberReport.LocalReport.DataSources.Add(masterData); ResignMemberReport.LocalReport.ReportEmbeddedResource = "Nube.Reports.NUBEBranchAdviceList.rdlc"; ReportParameter[] rp = new ReportParameter[3]; if (!string.IsNullOrEmpty(cmbBranch.Text)) { rp[0] = new ReportParameter("BranchName", "Branch Name : " + cmbBranch.Text); } else { rp[0] = new ReportParameter("BranchName", ""); } rp[1] = new ReportParameter("Month", String.Format("{0:dd MMM yyyy} - {1:dd MMM yyyy}", dtpDateFrom.SelectedDate.Value, dtpDateTo.SelectedDate.Value)); if (!string.IsNullOrEmpty(cmbBranch.Text)) { rp[2] = new ReportParameter("BranchCode", cmbBranch.SelectedValue.ToString()); } else { rp[2] = new ReportParameter("BranchCode", ""); } ResignMemberReport.LocalReport.SetParameters(rp); ResignMemberReport.RefreshReport(); } else { MessageBox.Show("Resigned Member's Not Found !"); } }