title: Showing RDLC report in Asp.Net with report viewer
body: <p>Am using VS 2010 and created a sample web application. Added a dataset and report and created an SP which just return one row. No variables included as of now. Just simple SP w/o any parameters. In the web app, added an aspx page and in that page added a report viewer control.
   My Aspx page goes as below:</p>
  
  <pre><code>    &lt;rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
          Font-Size="8pt" InteractiveDeviceInfos="(Collection)" 
          WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt"&gt;
      &lt;/rsweb:ReportViewer&gt;
  </code></pre>
  
  <p>Code behind goes as below:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
          {
              ReportViewer1.Visible = true;
              ReportDataSource dataSource = new ReportDataSource("DataSet1", LoadData().Tables[0]);
              ReportViewer1.LocalReport.DataSources.Clear();
              ReportViewer1.LocalReport.DataSources.Add(dataSource);
              ReportViewer1.LocalReport.Refresh();
          }
  
          private DataSet LoadData()
          {
              var dataset = new DataSet();
              using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["CString"].ConnectionString))
              {
                  var command = new SqlCommand("[spSampleReport]")
                                    {
                                        Connection = con,
                                        CommandType = CommandType.StoredProcedure
                                    };
  
                  var adap = new SqlDataAdapter(command);
                  con.Open();
                  adap.Fill(dataset, "DataSet1");
              }
  
              return dataset;
          }
  </code></pre>
  
  <p>In my web config, have added following in httphandlers section:</p>
  
  <p></p>
  
  <p>When Running, there is nothing shown on the page. Even the report viewer toolbars are not shown. </p>