Friday, December 10, 2010

Unable to load Print Client control while browsing reports using asp.net application for RS2008


For Reporting Services 2008, there is no limitation of version required.


check the version of the ReportViewer control.
You do this by viewing a report on a client machine.
Then right click on the report and select “View Source”.
Locate the line that looks like this:
"/TestRSClientPrintReportViewer/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=X.Y.ZZZZ 3. Now, if the control type is “Reserved.ReportViewerWebPart.axd” then this is an issue with SharePoint. The “Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies” has been updated to work with the new rsclientprint.dll. Download center link: 
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-b331-132274ae8c84&displaylang=en


 If the control type is “Reserved.ReportViewerWebControl.axd” we should check the following:


We have 2 different major versions here: 8.00.50727 and 9.00.XXXX.


If you see version 8.00.50727 this means you are browsing reports from within CRM or using the ReportViewer control in a custom 2005 web application.
If you see version 8.00.50727 and the version is earlier than 8.00.50727.1843 then you should install Report Viewer Redistributable 2005 Service Pack 1 on the ReportServer or on the CRM server:
Microsoft Report Viewer Redistributable 2005 Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=en


If you see version 9.00.XXXX or 9.0.XXXX then you are browsing through Report Manager, Report Server or perhaps a customer web application built with VS 2008.
Then you should install the below on the report server:
Microsoft Report Viewer 2008 SP1 Redistributable
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en


After having updated the ReportViewer control you must issue an iisreset command so that the updated controls will take effect.


Client Side steps that could be required, in case even after upgrading the Report Server, the issue is not fixed –


1. Unregister RSClientPrint.dll in c:\windows\system32 folder.
2. Delete all RSClientPrint.dll and RSClientPrint*.rll files from c:\windows\system32 folder.
3. Go to Windows\Downloaded Program Files and delete the RSClientPrint 2005 Class
4. Set the IE Intranet setting to prompt for ActiveX downloads
5. Run the Report.
6. Install the SQL Server ActiveX plugging when prompted.
7. Check the Downloaded Program Files through explorer and command prompt. It should say RSClient 2005 Class.
8. If a message comes up stating that “An error occurred during printing (0x80070006)”, then reboot machine.
9. Run the Report.
10. If the error shows up again, go to c:\windows\downloaded program files in explorer and right click and remove the RSClientPrint 2005 Class.

1 comment:

  1. Hi
    thanks for you post.
    in my scenario i get the same error and its from MS CRM 2011.
    i have SQL server 2008 R2 installed with RS.
    i have reinstalled the component many times, but no result.
    any idea on this.

    Thanks in advance.

    Regards,
    yes.sudhanshu

    ReplyDelete