Error message when you try to print a SQL Server 2005 Reporting Services report on a client computer: "Unable to load client print control"

Article translations Article translations
Article ID: 967511 - View products that this article applies to.

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION IN RESPONSE TO EMERGING OR UNIQUE TOPICS, AND MAY BE UPDATED AS NEW INFORMATION BECOMES AVAILABLE.

DISCLAIMER

MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE FOR ANY PURPOSE. THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S) AND/OR THE PROGRAM(S) DESCRIBED HEREIN AT ANY TIME.

For more information about the terms of use, visit the following Web site:
http://support.microsoft.com/tou/
Expand all | Collapse all

SYMPTOMS

On a computer that has Microsoft SQL Server 2005 Reporting Services installed, you install the cumulative security update for ActiveX that is described in the following knowledge base article:
956391 Microsoft Security Advisory: Update Rollup for ActiveX Kill Bits
When you try to print a SQL Server 2005 Reporting Services report on a client computer, you receive the following error message:
Unable to load client print control

Additionally, this problem may affect any other application that uses the Report Viewer control, such as Microsoft Customer Relationship Manager (CRM) or a custom application developed in Microsoft Visual Studio. This problem may also affect Report Viewer add-in (Web part) that is used for integration between Reporting Services and SharePoint.

RESOLUTION

For the printing functionality to work correctly, all relevant components must be updated. Most issues can be resolved by using the following procedure:
  1. Update the report server.
  2. Update the report viewer redistributable.
Therefore, to resolve this issue, follow these steps:
  1. Update the report server.
    Make sure that the version of the report server is 9.00.4266 or later. If the version is earlier than 9.00.4266, you must update the report server first.
    To update report server, install Cumulative Update 6 for SQL Server 2005 Service Pack 3 or a later version. For more information about Cumulative Update package 6 for SQL Server 2005 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:
    974648 Cumulative update package 6 for SQL Server 2005 Service Pack 3


    Note The file name of the update to use is SQL_Server_2005_SP3_Cumulative_Update_6.
  2. Update the report viewer redistributable on the applciation server (CRM, Sharepoint, or custom middle tier application)
    Check the version of the ReportViewer control. To do this, follow these steps:
    Install Microsoft Report Viewer Redistributable 2005 Service Pack 1 GDIPLUS.DLL Security Update from the following link:
    http://www.microsoft.com/downloads/details.aspx?familyid=0dfaf300-2b53-4678-a779-0d805ddfe538&displaylang=en

    In the specific case of SharePoint 2007 please additionally install the updated Reporting Services Add-In for SharePoint from:
    974648 Cumulative update package 6 for SQL Server 2005 Service Pack 3.
    http://support.microsoft.com/kb/974648


    Note The file name of the update to use here is is SQL_Server_2005_SP3_Cumulative_Update_6_RS.

    After you update the ReportViewer control, you must run the iisreset command to restart the Internet Information Services service so that the updated controls will take effect.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information, visit the following Web sites:
http://blogs.msdn.com/brianhartman/archive/2008/11/05/client-print-fails-to-load-after-microsoft-update-956391.aspx
http://blogs.msdn.com/psssql/archive/2009/10/15/reporting-services-and-the-ms09-062-gdr-gdi.aspx

Properties

Article ID: 967511 - Last Review: March 11, 2010 - Revision: 3.0
APPLIES TO
  • Microsoft SQL Server 2005 Reporting Services
Keywords: 
kbtshoot kbexpertiseadvanced kbsql2005rs kbsurveynew kbbug KB967511

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com