Microsoft Report Viewer is only displaying three fields, two of which are disabled. It should be displaying a large, fully functional report.
The sql server configuration has been vetted for by somebody who has done it many times and is running these same reports in a production environment. We've also scoured the web.config and haven't found anything out of place.
Here's an image of what the (broken) report looks like. The "End Date" and the "Stores" fields are disabled. Clicking View Report brings up the loading spinner, which then closes without changing anything or throwing errors.
We are seeing this problem on two different QA environments, one using old ASP.NET and one using ASP.NET MVC 4.
Web.config highlights
<sessionState mode="SQLServer" sqlConnectionString="Integrated Security=SSPI;Data Source=-------;" timeout="30" />
<compilation debug="true" targetFramework="4.0" >
<buildProviders>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</buildProviders>
</compilation>
<pages enableViewState="true" clientIDMode="AutoID">
<controls>
<add tagPrefix="rsweb" namespace="Microsoft.Reporting.WebForms" assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</controls>
</pages>
<system.web>
<httpHandlers>
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" />
</httpHandlers>
</system.web>
<system.webServer>
<handlers>
<add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</handlers>
</system.webServer>
Here are the relevant parts of the web page:
<asp:ScriptManager ID='scriptManager' runat='server' AsyncPostBackTimeout="1800" EnablePartialRendering="false" />
<rsweb:ReportViewer ID="ReportViewer" runat="server" OnReportError="ReportError"
Font-Names="Verdana" Font-Size="8pt" Height="685px" ProcessingMode="Remote" Width="985px"
InternalBorderColor="White" InternalBorderWidth="0px" BackColor="White">
<ServerReport />
</rsweb:ReportViewer>
We are at a loss for ideas. Has anybody seen anything like this?
It turns out that the reports were misconfigured after all. Thanks for the responses, though!