none
SQL Report ASP.NET Viewer 9.0 does not display correctly RRS feed

  • Question

  • I tried to display SQL reports in an ASP.NET report viewer on 64 bit Windows 2008 web server, but it just does display the icons correctly in the toolbar, also there is no content in the viewer, the same ASP.NET code works on another 32 bit Windows web server.

    1. Environment

    OS: 64 bit Windows 2008 web server (running IIS 7)
    .NET version: 3.5 with SP1
    ASP.NET Viewers: 9.0.0.0 with SP1 and 8.0.0.0
    DLLs in GAC: Microsoft.ReportViewer.Common, Microsoft.ReportViewer.ProcessingObjectModel, Microsoft.ReportViewer.WebForms, Microsoft.ReportViewer.WinForms for both versions 9.0.0.0 and 8.0.0.0
    Handler Mapping in IIS 7: a new handler was created for the web application:
         Path: Reserved.ReportViewerWebControl.axd
         Type: Microsoft.Reporting.Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
         Name: Reserved-ReportViewerWebControl-axd
    In web.config:

          <httpHandlers>
            <remove path="*.asmx" verb="*" />
            <add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
              validate="false" />
            <add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
              validate="false" />
            <add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
              validate="false" />
            <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
              validate="false" />
          </httpHandlers>

                <assemblies>
                    <add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
                    <add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

                    <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
                    <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
                    <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
                    <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
                </assemblies>

    2. Got advice from the following links (thanks very much for the authors)

    http://otkfounder.blogspot.com/2007/11/solving-reportviewer-rendering-issue-on.html
    http://ericphan.info/development/reserved-reportviewerwebcontrol-axd-not-found/

    I am pretty new to 64 bit Windows 2008, and running out of gas on this issue, can anyone help me out? Thanks very much for your helps.

    Thursday, February 11, 2010 12:04 AM

All replies

  • Find an anwser to this one ? I have tried all the standard stuff w/ messing w/ the web.config and installing different copies of the report viewer ..

     

    Christopher Rathermel


    -Christopher Rathermel
    Wednesday, May 5, 2010 8:14 PM