title: Report not showing up on report viewer
body: <p>I am developing a <code>c#</code> application where  I need to generate a report. I am a using a dataset which is filled with the data coming from a <code>stored procedure</code> which takes one parameter from the C# code. I am creating a parameter in <code>report1.rdlc</code> and populating it with the data from a text box. When I run the application I can’t see anything on report viewer. </p>
  
  <pre><code>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();
              }
          }
  </code></pre>