Databases
StackOverflow2013
Postsdbo
POI upgraded my .RDLC from VS 2008 to VS 2010 and now the Page is Blank when I run the report
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POI upgraded my .RDLC from VS 2008 to VS 2010 and now the Page is Blank when I run the report
    text
    copied!<p>At first the issue I had was easily found, then I added the Script Manager as suggested and that caused the error to go away. Now, it just doesn't render.</p> <p>It's a very simple report. When I don't "hide" the report at first, it will render, but time out, so I know it will work. It seems like I'm running into some type of Asynch Issue moving from SSRS 2008 and SSRS 2010. I have tried various properties with an Update Panel and the Async Rendering, and this did not help.</p> <p>Here is my basic Code</p> <p> </p> <pre><code> &lt;rsweb:ReportViewer ID="ReportViewer2" runat="server" Font-Names="Verdana" Visible="false" Font-Size="8pt" Height="564px" Width="1055px" &gt; &lt;LocalReport ReportPath="Reports/SingleUK.rdlc"&gt; &lt;DataSources&gt; &lt;rsweb:ReportDataSource DataSourceId="MainSqlDataSource" Name="DataSet1" /&gt; &lt;/DataSources&gt; &lt;/LocalReport&gt; &lt;/rsweb:ReportViewer&gt; &lt;asp:SqlDataSource ID="MainSqlDataSource" runat="server" ConnectionString="&lt;%$ ConnectionStrings:AncillaryProductionConnectionString %&gt;" SelectCommand="packsheets.procUKPacksheets" SelectCommandType="StoredProcedure" onselecting="MainSqlDataSource_Selecting"&gt; &lt;SelectParameters&gt; &lt;asp:FormParameter Type="Int32" DefaultValue="" FormField="StatusDropDownList" Name="Status" /&gt; &lt;asp:FormParameter Type="Int32" DefaultValue="" FormField="HoldDropDownList" Name="Hold" /&gt; &lt;asp:FormParameter Type="Int32" DefaultValue="0" FormField="NoteCategoryDropDownList" Name="Notes" /&gt; &lt;asp:FormParameter Type="Int32" DefaultValue="0" FormField="ShippingGroupDropDownList" Name="ShMeth" /&gt; &lt;asp:Parameter Direction="ReturnValue" Name="RETURN_VALUE" Type="Int32" /&gt; &lt;/SelectParameters&gt; &lt;/asp:SqlDataSource&gt; </code></pre> <p>and the Code Behind</p> <pre><code>protected void Page_Load(object sender, EventArgs e) { //if (!Page.IsPostBack) //{ // this.ReportViewer2.Visible = false; //} } protected void Button1_Click(object sender, EventArgs e) { this.ReportViewer2.Visible = true; this.ReportViewer2.LocalReport.Refresh(); } protected void MainSqlDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e) { if (e.Command.Parameters["@Status"].Value == null) { e.Command.Parameters["@Status"].Value = DBNull.Value; } if (e.Command.Parameters["@Hold"].Value == null) { e.Command.Parameters["@Hold"].Value = DBNull.Value; } } } </code></pre> <p>Does anyone have any idea on what else I could try? </p> <p>Thanks in advance!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload