title: Report viewer does not load, showing blank space - running local RDLC files
body: <p>I got a problem with reporting services, running local rdlc files on the 2005 version. </p>
  
  <p>I have in the HTML a report viewer set to run locally as follows : </p>
  
  <pre><code> &lt;rsweb:ReportViewer ID="ReportingServicesReportViewer" runat="server" Height="100%"
              ProcessingMode="Local" ShowParameterPrompts="False" Width="100%"&gt;
          &lt;/rsweb:ReportViewer&gt;
  </code></pre>
  
  <p>In the code</p>
  
  <pre><code>// create SqlConnection
          SqlConnection myConnection = new SqlConnection(ConnectionString);
          myCommand.Connection = myConnection;
          SqlDataAdapter da = new SqlDataAdapter(myCommand);
  
          //get the data
          DataSet data = new DataSet();
          da.Fill(data);
  
          if (data != null &amp;&amp; data.Tables.Count &gt; 0 &amp;&amp; data.Tables[0].Rows.Count &gt; 0)
          {
              ReportingServicesReportViewer.Visible = true;
              ltrStatus.Text = string.Empty;
  
              //provide local report information to viewer
              ReportingServicesReportViewer.LocalReport.ReportPath = Server.MapPath(Report.RDLCPath);
  
              //bind the report attributes and data to the reportviewer
              ReportDataSource rds = new ReportDataSource("DataSet1", data.Tables[0]);
              ReportingServicesReportViewer.LocalReport.DataSources.Clear();
              ReportingServicesReportViewer.LocalReport.DataSources.Add(rds);
              ReportingServicesReportViewer.LocalReport.Refresh();
          }
          else
          {
              ReportingServicesReportViewer.Visible = false;
              ltrStatus.Text = "No data to display.";
          }
  </code></pre>
  
  <p>When the method to populate the report viewer with the results of the report is executed, nothing comes up as if the report viewer is not even there.</p>
  
  <p><strong>What I did to trouble shoot till now:</strong></p>
  
  <ul>
  <li>Checked the event viewer for errors and this is the only thing related
  which I get,   [Domain]\sp_dbadmin    Reason:
  Failed to open the explicitly specified database. . However,
  my user which I am connecting is a sysadmin. I have checked that and
  am sure because I checked the sys.server_role_members</li>
  <li>I tried impersonating the logged in user, to no avail</li>
  <li>I created a specific user with sysadmin rights, and gave all access rights both from IIS and also on the sql server 2008.</li>
  </ul>
  
  <p>Has anyone encountered a problem similar to this, any ideas?</p>