Problems Using RSClientPrint
Sep 29, 2006
We are using VB.NET 2005 to develop a WinForms application that uses SQL Server 2005 Reporting Services to produce reports.
We want to print a large report programmatically without preview. RSClientPrint looked like a good solution but it produces an error when we try to use it.
Details...
I added Interop.RSClientPrintLib.dll Version 1.0.0.0 to my application and used the code sample I found at:
http://msdn2.microsoft.com/en-us/library/ms159195.aspx
The call to print looks like:
RSClientPrint.Print("http://ourServer/reportserver", strReportPathParameters, "Report_name")
This call generates an error message:
"An error occured during printing. (0x80004002)"
and throws an exception:
"Specified cast is not valid"
Any ideas appreciated.
View 5 Replies
ADVERTISEMENT
Mar 27, 2006
I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:
1. Print dialog box appears as expected
2. Press print
3. Dialog box appears saying "Print in progress"
4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.
I get the same error if I try to preview instad of print.
The (relevent) code is:
<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>
<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>
<body onload="printIt()">
Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.
Many thanks
Ian
View 4 Replies
View Related
May 19, 2006
I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.
1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?
2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?
3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?
Thanks
View 7 Replies
View Related
Jun 26, 2007
Hi,
We are using the RSClientPrint component to print reports from our web application. When we use it from IE all works fine. But on using the FireFox the print method fails. I am using following code to print
Code Snippet
var oRSClientPrint = window.document.getElementById("RSClientPrint");
alert(oRSClientPrint);
if (typeof oRSClientPrint.Print == "undefined")
{
alert("Unable to load client print control.");
return;
}
In FireFox above code fails by raising error message "Unable to load client print control.". As per me FireFox is not able to use the Print method of object, Can you help me on how we can make it to work with FireFox.
Thanks and Regards,
Nav
View 1 Replies
View Related
Jun 26, 2006
Hi ,
I m using rsclientscript in my application..i m using the following code in <script>
function Print()
{
RSClientPrint.MarginLeft = 12.7;
RSClientPrint.MarginTop = 12.7;
RSClientPrint.MarginRight = 12.7;
RSClientPrint.MarginBottom = 12.7;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 9;
RSClientPrint.Print('http://localhost/Reports/Pages/Report.aspx?ItemPath', '=%2fTestMonday%2fSrCorpLogo&CorporationId=2', 'Employee_Sales_Summary')
}
</script>
I m calling this script when user clicks the button in the webpage..
I m getting the dialog box properly..In that if i click preview button i m getting the following error
"An error occured trying to render the report. (0x80004005)"
Please help me out ..Very Urgent Issue..
Thanks in Advance..
Bhoopathi..
View 4 Replies
View Related
Mar 13, 2007
Hi All
We're having a technical issue integrating the print reports into the portal. I'm hoping maybe some of your guys can help. We're using the RSClientPrint component to print the reports. The problem appears to be a conflict between the & in the URL and the & in the parameter value's cube reference. Below is an HTML code snippet. The 1st button works fine for us, it prints everything and has no & in the parameter's cube references. The second button references specific User and Employee values and therefore has & in the cube reference and generates an error. We tried encoding the & as & but it did not help. Thanks.
<html>
<body>
<OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3"></OBJECT>
<script type="text/javascript">
function Print(ReportServer, ReportParameters, ReportTitle ) {
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print(ReportServer, ReportParameters, ReportTitle);
}
</script>
<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].[All]&UserUser=[User].[User].[All]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].[All]', 'SA.Report.6');"/>
<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].&[1]&UserUser=[User].[User].&[1]&[1]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].&[3356953]', 'SA.Report.6');"/>
</body>
</html>
Regards,
Nanda kumar R
View 3 Replies
View Related
Apr 8, 2008
I am getting a general protection fault when pressing the print icon in Reporting Services website.
Hi I found this article:
http://database.ittoolbox.com/groups/technical-functional/sql-server-l/reporting-services-2005-print-icon-causes-machine-to-reboot-1592477
but I can't figure ou how to "remove" the RSClientPrint Class add-on in IE 6.
P.S.
Why does something as simple as printing need to be an ActiveX control? There are all kinds of issues revolving around pushing this out using SMS for users without local admin permission.
View 4 Replies
View Related
May 14, 2007
I am using SQL 2005 with reporting services, I have very basic reports, most users can print fine with the print icon in the toolbar, some users get the Blue screen and have to reboot. They have the rsclientprint.dll loaded in the browser, we have deleted it and reloaded, what do I do ?
View 1 Replies
View Related
Mar 15, 2007
Hi,
I€™m hoping someone might be able to help me.
I have a Development Machine running Windows XP Professional SP2, with SQL Server 2005 including Reporting Services. I am developing an ASP.NET application using VS 2005, and am including Server Side Reports from SQL Server. Everything is working well, except when viewing the Reports.
The Reports when viewed from Reporting Services€™ Report Manager or from within the ASP.NET application only display the first page of the report, displaying the total number of pages as 0. As well, most of the functions on the report toolbar appear to be disabled. This occurs for any report viewed, even sample reports such as the Adventure Works Samples.
The problem only occurs when viewed from within Internet Explorer on the Development Machine. To overcome the problem, I have upgraded SQLServer to SP2, and removed and reinstalled Internet Explorer, but it made no difference. It appears to be related to the rsClientPrint ActiveX addon which should have been installed when the print icon was first selected. It appears not to have installed properly, but up to that point everything worked OK. Selecting the Print icon (or any other icon) since nothing happens. I€™m guessing here, but I suspect that the rsClientPrint addon needs to be reinstalled, but I don€™t know how to go about it. It is not listed within IE addon (where it is on other machines connecting to the Development Machine), nor is it listed within the €śC:WindowsDownloaded Program Files€?. But it is not being downloaded when the Print Icon is selected. I have checked all the Security settings for the environment to ensure that ActiveX programs are downloaded, and everything appears to be in order.
Would anyone be familiar with this problem or have any suggestions on how to go about resolving it? Any help would be appreciated as it is causing significant problems. Strange though, the reports appear fine when viewed from within the Server Manager.
View 1 Replies
View Related