Unable to load print control in ReportingService

超、凢脫俗 2022-04-01 15:18 215阅读 0赞

低版本出现报表无法打印的问题（客户端无法加载打印控件）

SP2地址：

[http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=4603c722-2468-4adb-b945-2ed0458b8f47][http_www.microsoft.com_downloads_details.aspx_displaylang_zh-cn_FamilyID_4603c722-2468-4adb-b945-2ed0458b8f47]

SP3地址：

[http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4][http_www.microsoft.com_downloads_details.aspx_displaylang_zh-cn_FamilyID_ae7387c3-348c-4faa-8ae5-949fdfbe59c4]

Microsoft Report Viewer Redistributable 2008

[http://www.microsoft.com/downloads/details.aspx?familyid=CC96C246-61E5-4D9E-BB5F-416D75A1B9EF&displaylang=en][http_www.microsoft.com_downloads_details.aspx_familyid_CC96C246-61E5-4D9E-BB5F-416D75A1B9EF_displaylang_en]

Problem:

Unable to load client print control.

Cause:

This issue is seen when KB 956391 has been installed on the client.

Microsoft Security Advisory: Cumulative security update for ActiveX

[http://support.microsoft.com/?id=956391][http_support.microsoft.com_id_956391]

This update killbits an older version of the RSClientPrint, due a vulnerability on it.

But for this update to work the report server must have been patched as well and perhaps also the ReportViewer control has to be updated.

You should leave KB956391 installed on the client machines and then check the below.

Resolution:

First check the report server version.

It must be 9.00.3073 or 9.00.3282.

If not, update the report server:

Security Update for SQL Server 2005 Service Pack 2 (KB954607)

[http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5148b887-f323-4adb-9721-61e1c0cfd213][http_www.microsoft.com_downloads_details.aspx_displaylang_en_FamilyID_5148b887-f323-4adb-9721-61e1c0cfd213]

Now check the version of the ReportViewer control.

You do this by having the customer open a report for viewing on a client machine.

Then have them right click on the report and select “View Source”.

Locate the line that looks like this:

Now, if the control type is “Reserved.ReportViewer**WebPart**.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][http_www.microsoft.com_downloads_details.aspx_FamilyID_1e53f882-0c16-4847-b331-132274ae8c84_displaylang_en]

If the control type is “Reserved.ReportViewer**WebControl**.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 the below 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][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][http_www.microsoft.com_downloads_details.aspx_FamilyID_bb196d5d-76c2-4a0e-9458-267d22b6aac6_DisplayLang_en]

This will bring you up to version 9.0.**30729.1** for the ReportViewer control.

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

**MORE**

Due to the great confusion I perceive about this error and its possible causes and solutions, I decided to remove my 3 old posts that talked about this error and create a single and more complete posts that I hope helps you resolve all the possible causes of this error when trying to print reports in Reporting Services.

*“Unable to load client print control”*

**POSSIBLE CAUSES AND PROPOSED SOLUTIONS:**

There could be 2 possible causes for this issue, very differnt from each other:

**1. This error could be caused by a known update to the RSClientPrint control**  (MS09-062): [http://support.microsoft.com/kb/971023][http_support.microsoft.com_kb_971023]

There are some fixes already built for this (1. To fix direct accesses to Report Manager 2. To fix applications that access Report Manager like CRM in your case). See bellow:

1. To fix accesses to Report Manager you should install the following in the Report Server machine:

**Service Pack 3 de Microsoft SQL Server 2005**

[http://www.microsoft.com/downloads/details.aspx?displaylang=es&FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4][http_www.microsoft.com_downloads_details.aspx_displaylang_es_FamilyID_ae7387c3-348c-4faa-8ae5-949fdfbe59c4]

and

**Cumulative update package 8 for SQL Server 2005 Service Pack 3**

[http://support.microsoft.com/kb/978915][http_support.microsoft.com_kb_978915]

2. To fix accesses to the Reporting Services from an application (like CRM, SharePoint or a web application) you would need to install the fixes bellow. They will be different depending on the version of the Report Viewer control:

To check the version of the ReportViewer control.

1. Open a report for viewing on a client machine  
2. Then right click on the report and select “View Source”.

Locate the line that looks like this:  
<script src="http://blogs.msdn.com/TestRSClientPrintReportViewer/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=X.Y.ZZZZ

a) 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][http_www.microsoft.com_downloads_details.aspx_FamilyID_1e53f882-0c16-4847-b331-132274ae8c84_displaylang_en]

b) 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 or machine where the web application is running:

Microsoft Report Viewer Redistributable 2005 SP1 (Full Installation)

[http://www.microsoft.com/downloads/details.aspx?familyid=E7D661BA-DC95-4EB3-8916-3E31340DDC2C&displaylang=en][http_www.microsoft.com_downloads_details.aspx_familyid_E7D661BA-DC95-4EB3-8916-3E31340DDC2C_displaylang_en]

and

Report Viewer Redistributable 2005 Service Pack 1 GDIPLUS.DLL Security Update

[http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0dfaf300-2b53-4678-a779-0d805ddfe538][http_www.microsoft.com_downloads_details.aspx_displaylang_en_FamilyID_0dfaf300-2b53-4678-a779-0d805ddfe538]

c) If you see version 9.00.XXXX or 9.0.XXXX then you are browsing through Report Manager, Report Server or perhaps a custom web application built with VS 2008.  
Then you should install the below on the report server and in the machine where the web application is running:

**Microsoft Report Viewer 2008 SP1 Redistributable**  
[http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en][http_www.microsoft.com_downloads_details.aspx_FamilyID_bb196d5d-76c2-4a0e-9458-267d22b6aac6_DisplayLang_en]

And

**Report Viewer Redistributable 2008 Service Pack 1 GDIPLUS.DLL Security Update**

[http://www.microsoft.com/downloads/details.aspx?familyid=6aaa74bd-a46e-4478-b4e1-2063d18d2d42&displaylang=en][http_www.microsoft.com_downloads_details.aspx_familyid_6aaa74bd-a46e-4478-b4e1-2063d18d2d42_displaylang_en]

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

**2. Or it could be a permissions issue:**

When trying to print reports from Reporting Services, the RSClientPrinty control needs to be downloaded and installed to the client machines. This is done automatically the first time a user tries to print a report and the users need to be administrators or Power Users in order to be able to download the control though the web.

Users that are not administrators nor Power Users don’t have permissions to deploy of the RsClientPrint control to IE from the server (not allowed installing ActiveX components)

This happens the first time you run a report or after installing some cumulative updates or service packs that modifies this control and needs to be redeployed. Each time the client clicks on the print button; there is a round trip to the server to check if the client has the latest version.

The following links explains that you need administrator permissions in order to download the print control to download it from the server:

[http://msdn.microsoft.com/en-us/library/ms159190(SQL.90).aspx][http_msdn.microsoft.com_en-us_library_ms159190_SQL.90_.aspx]

**2 POSSIBLE ALTERNATIVES:**

Deploy the control manually:

If the users weren’t administrators or power users, the issue could be resolved by deploying the files manually:

1.Go to C:\\Program Files\\Microsoft SQL Server\\MSSQL.x\\Reporting Services\\ReportServer\\bin on the report server and copy the rsclientprint.cab file

2.Extract the files from the rsclientprint.cab file.

3.Copy all the files to the client computer to Windows\\Downloaded Program Files (you might need to do it using the command windows)

c:\\print\\RSClientPrint.dll

c:\\print\\rsclientprint.inf

c:\\print\\RsClientPrint\_1028.rl

c:\\print\\RsClientPrint\_1031.rl

c:\\print\\RsClientPrint\_1033.rl

c:\\print\\RsClientPrint\_1036.rl

c:\\print\\RsClientPrint\_1040.rl

c:\\print\\RsClientPrint\_1041.rl

c:\\print\\RsClientPrint\_1042.rl

c:\\print\\RsClientPrint\_2052.rl

c:\\print\\RsClientPrint\_3082.rl

4.Register RSClientPrint.dll by opening a command line (Start->Run) regsvr32 \[path\]RSClientPrint.dll

Or creating a script to install the control using “Run As”

“Run As” is a tool that allows running programs as a different user than the currently logged-on user. It is described in the article:

**How to enable and use the "Run As" command when running programs in Windows**

[http://support.microsoft.com/?id=294676][http_support.microsoft.com_id_294676]

Steps to create the script would be:

1. On a Domain Controller, create a share with the appropriate rights for a "simple user"  
2. On this share create a file called runas.vbs with the following code:

'  
'RunAs Helper  
'Syntax: runas.vbs <username> <command>  
'  
set args=wscript.arguments  
username = args(0)  
' Enter the password in the variable pass  
pass = "**administrator** **password**"  
'Get the command arguments  
for i=1 to args.count - 1  
command = command & args.item(i) & " "  
Next  
set shell=wscript.createobject("Wscript.shell")  
'Run runas.exe  
shell.run "runas.exe /user:" & username & " """ & command & """",2,FALSE  
'Wait for runas.exe to load, this time could be shorter, but is set to 1000  
'to be safe  
wscript.sleep(1000)  
'Send the password and hit enter  
shell.sendkeys pass & "\{ENTER\}"  
wscript.sleep(1000)

3. Extract the dll and inf files from your ActiveX on the share.  
4. Download the Windows Script Encoder, available on

[http://www.microsoft.com/downloads/details.aspx?FamilyId=E7877F67-C447-4873-B1B0-21F0626A6329&displaylang=en][http_www.microsoft.com_downloads_details.aspx_FamilyId_E7877F67-C447-4873-B1B0-21F0626A6329_displaylang_en]

and encrypt the original vbs file: original\_vbs\_file.vbs vbs\_encrypted\_file.vbe

The script encoder is a command-line tool that allows a scriptwriter to protect the contents of a script from unauthorized copies or modifications while ( at the same time ) allowing the script to run.

5- Create a logonscript with the following instructions:

net use z: \\\\server\\share <file://\\\\server\\share> 'Map the share to a local drive.

The files need to be local so as to be installed..

z:\\vbs\_encrypted\_file.vbe domain\\admin rundll32.exe setupapi,InstallHinfSection DefaultInstall 132 z:\\rapport.inf  
z:\\vbs\_encrypted\_file.vbe domain\\admin rundll32.exe setupapi,InstallHinfSection DefaultInstall 132 z:\\vbs.inf  
net use z: /d 'Delete the mapping

I hope this helps,

**Maria Esteban**

**Reporting Services Support Engineer**

[http_www.microsoft.com_downloads_details.aspx_displaylang_zh-cn_FamilyID_4603c722-2468-4adb-b945-2ed0458b8f47]: http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=4603c722-2468-4adb-b945-2ed0458b8f47
[http_www.microsoft.com_downloads_details.aspx_displaylang_zh-cn_FamilyID_ae7387c3-348c-4faa-8ae5-949fdfbe59c4]: http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4
[http_www.microsoft.com_downloads_details.aspx_familyid_CC96C246-61E5-4D9E-BB5F-416D75A1B9EF_displaylang_en]: http://www.microsoft.com/downloads/details.aspx?familyid=CC96C246-61E5-4D9E-BB5F-416D75A1B9EF&displaylang=en
[http_support.microsoft.com_id_956391]: http://support.microsoft.com/?id=956391
[http_www.microsoft.com_downloads_details.aspx_displaylang_en_FamilyID_5148b887-f323-4adb-9721-61e1c0cfd213]: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5148b887-f323-4adb-9721-61e1c0cfd213
[http_www.microsoft.com_downloads_details.aspx_FamilyID_1e53f882-0c16-4847-b331-132274ae8c84_displaylang_en]: http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-b331-132274ae8c84&displaylang=en
[http_www.microsoft.com_downloads_details.aspx_familyid_82833F27-081D-4B72-83EF-2836360A904D_displaylang_en]: http://www.microsoft.com/downloads/details.aspx?familyid=82833F27-081D-4B72-83EF-2836360A904D&displaylang=en
[http_www.microsoft.com_downloads_details.aspx_FamilyID_bb196d5d-76c2-4a0e-9458-267d22b6aac6_DisplayLang_en]: http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en
[http_support.microsoft.com_kb_971023]: http://support.microsoft.com/kb/971023#appliesto
[http_www.microsoft.com_downloads_details.aspx_displaylang_es_FamilyID_ae7387c3-348c-4faa-8ae5-949fdfbe59c4]: http://www.microsoft.com/downloads/details.aspx?displaylang=es&FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4
[http_support.microsoft.com_kb_978915]: http://support.microsoft.com/kb/978915
[http_www.microsoft.com_downloads_details.aspx_familyid_E7D661BA-DC95-4EB3-8916-3E31340DDC2C_displaylang_en]: http://www.microsoft.com/downloads/details.aspx?familyid=E7D661BA-DC95-4EB3-8916-3E31340DDC2C&displaylang=en
[http_www.microsoft.com_downloads_details.aspx_displaylang_en_FamilyID_0dfaf300-2b53-4678-a779-0d805ddfe538]: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0dfaf300-2b53-4678-a779-0d805ddfe538
[http_www.microsoft.com_downloads_details.aspx_familyid_6aaa74bd-a46e-4478-b4e1-2063d18d2d42_displaylang_en]: http://www.microsoft.com/downloads/details.aspx?familyid=6aaa74bd-a46e-4478-b4e1-2063d18d2d42&displaylang=en
[http_msdn.microsoft.com_en-us_library_ms159190_SQL.90_.aspx]: http://msdn.microsoft.com/en-us/library/ms159190%28SQL.90%29.aspx
[http_support.microsoft.com_id_294676]: http://support.microsoft.com/?id=294676
[http_www.microsoft.com_downloads_details.aspx_FamilyId_E7877F67-C447-4873-B1B0-21F0626A6329_displaylang_en]: http://www.microsoft.com/downloads/details.aspx?FamilyId=E7877F67-C447-4873-B1B0-21F0626A6329&displaylang=en