473,396 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How do I print from Reporting Services AUTOMATICALLY in VB.Net web app?

We are converting some reports from Crystal Reports to Microsoft SQL Reporting Services (SSRS) in an ASP 2.0 VB.Net web app. Crystal had a function called PrintToPrinter which was being used to programmatically print to a network printer that we specified in the code as soon as the user clicked a button on the screen. The printer dialog box did not appear. It was true one-click printing.

I need to figure out how to do the same thing in SSRS. Right now we have our SSRS reports rendering to a PDF and opening in a new window when the user clicks the button, forcing the user to then click another print button on that screen to print the report.

I've been looking all over the web for how to do this but am not finding much luck.

Supposedly there is a way to call an SSRS web service, render the report as an EMF, and use things like System.Drawing.Imaging and System.Drawing.Printing to send the report to the printer. I can't find any detailed examples of how to do this in VB.Net code however. I'm trying to avoid doing this from scratch because I have very little time left to complete this. Posts about this all seem to be from 2004 so I'm not sure if something better has come along since then. This link shows an example of this in C# but since I don't know C# I can hardly make head or tail of it:

http://blogs.msdn.com/bryanke/articles/71491.aspx

I also read some suggestions that there might be a way to use an RSPrintClient ActiveX control that's new in SSRS 2005 but I can't find any examples and it sounds like they may still pop up the print dialog box. I was thinking of using JavaScript to fire a window.print and then close the window that's showing the PDF, but I think this would still force the user to click the print dialog box, plus it would flsh onto their screen and be less invisible of a process.

In addition, I read you might be able to use Windows Script Host to print programmatically on the client, but again I'm unfamiliar with it and I don't think there are any examples integrating that with SSRS out there.

Finally I found an example that I believe was saving the PDF to disk and sending some kind of function calls to Adobe to make Adobe print it in the background. I put the code in my app but it just didn't work.

Anyway, you can see I've looked everywhere and am not finding what I need. If anyone has any working examples of VB.Net web app code that makes it possible to do automatic, programmatic printing of SSRS reports to a network printer, please post it, send it to me, or direct me to where I can find it.

Thank you!
Mar 14 '08 #1
0 3051

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: rattanan | last post by:
Dear All, I am pursing a Master's degree from Monash University. Currently, I am in the final stage of my program. I am doing a research project examining the impact of Microsoft's Reporting...
0
by: rattanan | last post by:
Subject: A Student Needs Your Help with Research Dear All, I am pursing a Master’s degree from Monash University. Currently, I am in the final stage of my program. I am doing a research...
8
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a...
0
by: Billy Cormic | last post by:
Hello, I just installed Reporting Services. It seems to be a pretty cool and usefull tool. I would like to use it for an upcomming project but I need Reporting Services to be able to...
0
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio...
2
by: Brad Pears | last post by:
I have a vb.net 2005 application and am using the print preview screen. This screen has a printer icon on it that the user can use to print the document currently being viewed. It uses the default...
3
by: =?Utf-8?B?Sm9uIEphY29icw==?= | last post by:
We use SQL Server 2000 We user VS 2005 How can we use SQL Server reporting Services? Thanks,
3
by: Blasting Cap | last post by:
I'm using VS 2005, SQL 2005 reporting services. SQL reporting services is working, and I have it both on my local computer, as well as on a server. I've created a report in the SQL Business...
18
by: =?Utf-8?B?SGVyYg==?= | last post by:
I'm using a ReportViewer in ASP.NET. From the development environment it works fine. When published and I try to open the page with the ReportViewer I get the error: An internal error occurred...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.