public void GenerateBranchwiseReport() { conn.Open(); SqlCommand BranchReportcmd = new SqlCommand("select [am/bsi name] from masterlookup where [asc type]='BRANCH' group by [am/bsi name]", conn); SqlDataReader BranchReportread = BranchReportcmd.ExecuteReader(); while (BranchReportread.Read()) { BranchManagerName.Add(BranchReportread.GetValue(0).ToString()); } conn.Close(); foreach (string managername in BranchManagerName) { conn.Open(); SqlCommand GetReportDatacmd = new SqlCommand(); GetReportDatacmd.CommandText = "USP_BranchwiseReport"; GetReportDatacmd.CommandType = CommandType.StoredProcedure; GetReportDatacmd.Parameters.Add(new SqlParameter("@BranchManagerName", managername)); GetReportDatacmd.Connection = conn; GetReportDatacmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(GetReportDatacmd); DataSet ds = new DataSet(); da.Fill(ds); conn.Close(); reportViewer1.Reset(); this.reportViewer1.Visible = true; string reportname = @"d:\users\administrator\documents\visual studio 2010\Projects\ReportwithParameter\ReportwithParameter\Report1.rdlc"; this.reportViewer1.LocalReport.ReportPath = @"d:\users\administrator\documents\visual studio 2010\Projects\ReportwithParameter\ReportwithParameter\Report1.rdlc"; ReportParameter[] param = new ReportParameter[1]; param[0] = new ReportParameter("ManagerName", managername); this.reportViewer1.LocalReport.SetParameters(param); ReportDataSource ReportBranch = new ReportDataSource("DatasetWithParameter.USP_BranchwiseReport", ds.Tables[0]); this.reportViewer1.LocalReport.ReportEmbeddedResource = reportname; this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DatasetWithParameter.USP_BranchwiseReport", ds.Tables[0])); //this.reportViewer1.LocalReport.DataSources.Add(ReportBranch); this.reportViewer1.LocalReport.Refresh(); //SendEmail(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)