Reporting Services :: Error Unable To Load Client Print Control
Nov 16, 2015
We have recently upgraded our .Net web application from a windows 2003 server to a windows 2012 server. Since this happened users that are trying to print a reporting services report is getting the error "Unable to load client print control". We are using reporting services 2012, but the application is using the 8 version of the viewer. The reporting services server did not change only the application server. The code for the application did not change.
UPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)
UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.
My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."
I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.
Any ideas how to support Reporting Services "Print" from within a WebBrowser control?
When you display a SQL Reporting Services report to the screen in the header there is a Printer Icon displayed. When we click this icon we get an error message "Unable to load client print control ".
Does anyone know what we need to load or what we need to do to resolve this so that we can print the report directly to teh printer, rather than having ot prinnt the web page, which also prints all the Web headre information
As most are aware by now, the Report Viewer controls for reporting services in 12.0 and prior rely on ActiveX to work. Â This causes compatibility issues for any non-IE browser, and as of IE11 and now Windows 10 Edge browser it's causing issues for even IE. Â Research suggests that SSRS 2014 switched out to Silverlight:
[URL]
However, Silverlight uses NPAPI which is another technology for which all browsers are ending support. Â As of this writing, Chrome has already ended support. Â Similarly/Coincidentally Java support is ending as well.
My question is, what are Microsoft's plan to restore functionality such as print/search for browsers where ActiveX/Silverlight cannot be used since this support is no longer strictly a 3rd party browser situation?
It seems the features are disabled when using any of the above because of compatibility issues with scripting/ActiveX not being properly supported by the FireFox and Chrome.
I believe the control determines the browser you are using is not IE and will not render the controls to prevent unexpected behavior because if the lack of ActiveX support. This can be seen when you compare the HTML of a page using IE8 and that of either IE11, FF, Chrome you'll see that the HTML for a zoom drop down control will show up in the IE8 browser and not in the others.
As for IE11 it presents itself as a Mozilla browser. eg: "User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko" so when the control see's this it wont generate any of the controls believing the browser can't support it, even though IE11 should certainly be capable of doing so. I wanted to know if this is correct and if this is a bug?
Browser Support for ReportViewer "The ReportViewer Web server control is used to embed report functionality in an ASP.NET Web application. The type of browser used to view the application determines the kind of functionality that you can provide in a report. Use the table provided in this topic to find out which of the supported browsers are subject to report functionality restrictions."
The page mentions that the following wont be supported by other browsers The following features are not supported in third-party browsers:
Document mapSearching within the reportZoomFixed table headersThe progress indicator for report processing (a green spinning wheel) is not available for server reports, or for locally processed reports that are configured for asynchronous processing.
Where or how can I download the Active X control for the client Print for the SSRS 2000. The reason is I want to push this Active X control to the clients' machines. Instead of waiting for them to download theirself who don't have permissions to do it.
If divisor is "0" I need to print the Field, but for me it displaying #Error. If I pass any value it is working fine. It is not working only for the Field.
I have installed SQL Server 2005 with Reporting Services on Windows Server 2003. I can run through reporting services configuration and completed all the required steps to initialize it. I can access the reports through //localhost/reportserver and I can also access the reports through Microsoft CRM. But I cannot access the Report Manager (//localhost/reports). I get this Error: Server Error in '/Reports' Application.
Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.
WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].
Stack Trace:
[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0 System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211 System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141 System.Reflection.Assembly.Load(String assemblyString) +25 System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32
[ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596 System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70 System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177 System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180 System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3561465 System.Web.Compilation.BuildManager.CompileGlobalAsax() +51 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462
[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612 System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521
[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
Any ideas? I have done some searching, but could not find any viable solutions. Please Help
.NET Permissions Error in Reporting Services when not using a custom assembly: I need help resolving a permissions error I€™m taking in a SQL RS 2005 report. I have a report that that is includes the following code fragment in Report Properties -> Code: Function rtf2text(ByVal rtf As String) As String Dim rtfcontrol As New System.Windows.Forms.RichTextBox Try rtfcontrol.Rtf = rtf Return rtfcontrol.Text Catch ex as Exception Return ex.Message End Try End Function I reference the .NET System.Windows.Forms DLL under Report Properties -> References -> References, Assembly Name (heading): System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 I have a text box with the following expression: =code.rtf2text(First(Fields!EndingQuoteComment.Value, "QuoteHeader")) And I€™ve verified, by removing the code.rtf2text command that is populated with the following: { tf1ansiansicpg1252deff0deflang1033{fonttbl{f0fromanfprq2fcharset0 Times New Roman;}{f1fnilfcharset0 Arial;}} viewkind4uc1pardif0fs32 ** Ending Quote Comments **par 0i0f1fs17par } When I run the preview in Visual Studio is correctly strips the RTF and displays just €œ** Ending Quote Comments **€?. When I €˜RUN€™ locally or deploy to a SQL RS 2005 Server and run the report I take the following error: Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I€™ve tried everything that I can think of on the server to make this work. I finally put together a Win 2003 box with SQL 2005, IIS, and RS 2005 running on it in a virtual machine to be 100% sure I had a standard clean install and deployed the report and I€™m getting the same error. Below I€™ve included a basic standalone RDL file that demonstrates my issue. I get the error referenced above when I deploy the RDL below. Any ideas or suggestions are greatly appreciated?
<?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <BottomMargin>0.25in</BottomMargin> <RightMargin>0.25in</RightMargin> <PageWidth>7.75in</PageWidth> <rdrawGrid>true</rdrawGrid> <InteractiveWidth>7.75in</InteractiveWidth> <rdnapToGrid>true</rdnapToGrid> <Body> <ReportItems> <Textbox Name="textbox21"> <Left>0.25in</Left> <Top>0.25in</Top> <rdefaultName>textbox21</rdefaultName> <Width>6.375in</Width> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontSize>7.5pt</FontSize> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>1.375in</Height> <Value>=code.rtf2text("{ tf1ansiansicpg1252deff0deflang1033{fonttbl{f0fromanfprq2fcharset0 Times New Roman;}{f1fnilfcharset0 Arial;}} viewkind4uc1pardif0fs32 ** Ending Quote Comments **par 0i0f1fs17par } ")</Value> </Textbox> </ReportItems> <Height>5.25in</Height> </Body> <rd:ReportID>8804486c-882f-493c-8dfb-b2f778a24b21</rd:ReportID> <LeftMargin>0.25in</LeftMargin> <CodeModules> <CodeModule>System.Windows.Forms, Version=2.0.50727.42, Culture=neutral, PublicKeyToken=b77a5c561934e089</CodeModule> </CodeModules> <Code>Function rtf2text(ByVal rtf As String) As String Dim rtfcontrol As New System.Windows.Forms.RichTextBox Try rtfcontrol.Rtf = rtf Return rtfcontrol.Text Catch ex as Exception Return ex.Message End Try End Function </Code> <Width>7.25in</Width> <InteractiveHeight>10in</InteractiveHeight> <Language>en-US</Language> <TopMargin>0.25in</TopMargin> <PageHeight>10in</PageHeight> </Report>
I have created a custom library(CodeLibrary) which internally references the dlls Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client.
I added this custom Dll codelibrary.dll to my SSRS report. and the expression of one of the field asÂ
=codelibrary.codefunction.GetValue(1000) Â codefunction is the class and GetValue is the method.
When I preview the report, I get the error "Error while loading code module:
'CodeLibrary,Version=1.0.0.0,Culture=neutral,PublicKeyToken=null'. Could not load file or assembly 'CodeLibrary,Version1.0.0.0, Culture=neutral,PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."
I am using VS2013, I have placed the custom library DLL in the path
C:Program FilesMicrosoft Visual Studio 12.0Common7IDEPrivateAssemblies
I have tested the custom library with a WPF application and it works fine.
I am not able to figure out what is causing this error.
We are having problems printing Reports (when printing by clicking on the AcitiveX print control), where the font for the fields are set to "C39HrP24DhTt" (barcode).
While viewing the report it displays as Barcodes but while printing, the Barcode does not get printed, but the string gets printed.
Environment: SSRS 2005
Using the ReportViewer Control in a .Net 2.0 Web App to render the reports.
BarCodes print fine in the following situations:
1. When the Report is exported to Excel and when printed from there
2. When you click on the print button on Internet Explorer
3. When saving as html (from view source) and opening that html document and printing.
BarCodes do NOT get printed in the following situation:
1. When printing by clicking on the "Print" (Active X Control) icon. Even the "Print Preview" does not show the Barcode.
I have a report that needs to be on landscape, but am only limited to printing portrait style when I render a PDF report in reporting services. Is it possible to render a report in landscape or even better, size the PDF via reporting services.
1. We have been using Sql Server 2008 R2 and its reporting services engine.
In the application we used Report Viewer (version 9).
When the report is taken for the first time, couple of messages pops up.
a. Unable to Load print control b. Install Sql Server Reporting Services 2008 R2.
These messages are fine, but we noticed that the second message is not consistent. When the application is deployed in staging server which is as same as the production server except for the power (CPU, RAM), the second message is "Install Sql Server 2008". Why is this happening?
2. To support IE 11, we upgraded the Report viewer to version 11. Now the messages are different.
a. Printing is not available. Verify that ActiveX is enabled or try using IE from the desktop b. Install Sql Server Reporting Services 2008 R2. (Here again when deployed in staging server it says "Install Sql Server 2008").
Paper is 21cm x 9cmPrinter is Epson LX-300..When I set this paper size, SSRS turns orientation to landscape and prints as if clockwise right rotated!I tried creating custom paper on print server options without success. I also tried setting the same paper size in Report Builder and Print Server but failed again.
I'm currently using Sql server 2005 Reporting Services. I'm trying to take data and fill in a form that I'm making a background image. When I go to preview all the textboxes filled with data align with the fields in the background image form. When I go to print they are off by a inch or so horizontally. Can anyone help me on this topic.
I'm using SQL Server 2008 SP3 with Reporting Services 2008 SP3.
By opening my web application in IE9 and running report, i can print and show then print preview by clicking the "Print preview" button in printing dialog.
By opening my web application in IE11 and running report, i can print the report but if I click on the print preview on the print dialog nothing appears... Why?
I have a sheet of mailing labels in which the first three rows have been used. Â I want a parameter or something when running an SSRS label report where I can specify what row to begin printing on and how many rows I want to print. Â Is that possible?
In a new ssrs 2008 report that uses sql server 2012, I am suppose to create a report that prints on both sides of the same paper. The first side of the report will display custom data with a mailing address for the customer.
The second side (back side of the paper) will contain generic information. The second side of the paper will contain areas for the users within my large company to fill out and return to the user via inter-office mail.
Thus my question is can this happen in an SSRS 2008 report to print in a PDF and/or Word document on both sides of the paper? If this is possible would you tell me if the paper needs to be exported to PDF, Word, or if this can on both format(s)? If so, any reference how to accomplish this goal?
If this is not possible in SSRS 2008, is printing on both sides of the paper possible in ssrs 2008 r2 or ssrs 2012?
What version of ssrs report would work, and if the print (export) needs to be a PDF, Word, or either format?Â
Is there a support of printing report with matrix that is set to RTL (LayoutDirection) which displays in ReportViewr control with property RightToLeft set to RightToLeft.Yes in DisplayMode = PrintLayout.
The report looks fine in the report viewr in DisplayMode = Normal, but when goes to PrintLayout, it seems that the left data on page is rendered first.
Example: This is the display of the report viewer, I would like to print the columns by the same order it displays here:
And this is the result when clicking Print Preview: the first page displays the data of the last columns and if i go to the last page (page 9) i will see the data of the first column as displays in the previous gif, I don't have a clue why?
Is there a property that can be set to force the print layout to render RTL. Anyway, it seem to me as a bug since the Report Viewer displays the data correctly and renders the data RTL as expected.
I have created  web based  ssrs report with Report viewer  and I am trying to add Command button to print result of report reside in ReportViewer and I have worked with  code to generate. Is there any other way to work around without writing function or java script  on Extra print button to print  ssrs report.
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls;
As long as the output file is written to the local client, it completes successfully. But after changing the UNC path to another server with or without fully qualified names it is unable to open BCP host data-file. (sample shown below) ----------------------------------------------------------------- DECLARE @FileNamevarchar(2000), @bcpCommandvarchar(2000)
SET @FileName =REPLACE('\stladminy_drive ransfer maffrandauthors_'+CONVERT(char(8),GETDATE(),1)+'.txt','/','-')
SET @bcpCommand ='bcp "SELECT * FROM FKIAcctReceivable.dbo.PurchaseOrder" queryout "' SET @bcpCommand =@bcpCommand + @FileName + '" -T -c'
EXEC master..xp_cmdshell @bcpCommand
--------------------------------------------------- xp_cmdshell has been enabled and the user has sysadmin rights.
Anybody have the same problem and willing to help?
I am trying to use a reportviewer control (processing mode = remote) to view a rdl that is hosted on a server running MOSS, the reporting services are run in "sharepoint integrated mode". When i try to set the path to the RDL on the control like i usually do for an ASP.NET ReportViewer control, i get the error message posted below. I cant find anything on google, Please HELP
I receive this error "Setup was unable to load the master information file' when I lanch Control Panel, Add/Remove Programs, Add/Remove Windows Components.
Here is my problem: I have SQLEXPRESS running with Windows Authentication on a "server" PC named "ASUS1", and I need to connect from a "client" PC named "Presario1", user "Mauro", connected through a peer network (I use a cross-over cable); both PCs belongs to the same workgroup named "RMT-WORK", and they can see each others shared folders without problems.
I have installed the connectivity components + Management Studio Express on Presario1, and enabled named pipes and TCP/IP protocols; then I've got SQL Browser running. I have also added the Login "Guest" on ASUS1SQLEXPRESS.
When I start Management Studio Express on Presario1 and browse for servers I can select "ASUS1" as database engine but when I try to connect I receive "Error 40: could not open a connection to SQL Server" (same result using SQLCMD); I have tried to add on ASUS1SQLEXPRESS a user "Presario1Mauro" with "CREATE LOGIN [Presario1Mauro] FROM WINDOWS" but I receive a "Windows user not found" error...
We have a winforms application with local rdlc reports. Â On Surface Windows 8 Pro devices only, reports render such that they are scaled down and don't fill the page. Â If resolution is lowered on the device, the report scales up to fill the page.
 This affects the appearance in print layout and well as the actual printed size.
If we export to pdf, it renders to fill the page (as expected). Â If you print to pdf or to printer, the scale is shrunken.
If we change the resolution settings so that "Make  text and other items larger or smaller" is set to small, the issue is resolved except the tablet is not very usable on this setting.Is this a bug?
Hello Friends, I have created few reports in SSRS 2005 on Windows 2003 Standard. Previouly I was not able to view reports from my .ASPX page which contained a ReportViewer, after going throuhg some other threads I was able to create a snap-shot for my reports . But still I'm not able to view reports, each time I try to view the page I get a message box with a error as : "Unable to locate control SSRS 2005: oReportCell" the same error is displayed when i try to access my reports from "http://localhost/reports.....". But the funny thing is I'm able to view the reports when I use the following URL: "http://localhost/reportserver/pages/reportviewer.aspx?/<report>". I have applied all the Hotfixes & installed the latest Service packs. Any suggestions ???????
