Solved

Auto Printing from SQL Reporting Services

Posted on 2006-10-19
1
318 Views
Last Modified: 2008-01-09
Hi experts,

       I am looking for a way to automate the printing of three of my Reports Daily.  Basically, I have three different reports that each require a Start Date and an End Date Parameter.  These Reports need to be printed once a day.  I would like a way to send these three reports to a printer without user interaction.  For example, at 8:00 AM Everyday the reports would print to a local printer.  I want manually set the Start and End Date Parameters to something like End Date = now() and Start Date = Now() - 1 day.  I am using Reporting Services 2000.  I also have Visual Studio 2003 and I am familiar with the Report Viewer control.  I found a way using the Report Viewer control to auto export one report but not print.  I also briefely looked into using a script and running it from the command line to do the job.  Any way will work for me as long as it gets the job done.
0
Comment
Question by:straucha
1 Comment
 
LVL 14

Accepted Solution

by:
simon_kirk earned 500 total points
ID: 17776031
There's a sample delivery extension in the Reporting Server installation that will allow you to do this. It's unsupported by MS but it sould work. Once installed you setup a subscription to print to the printer and set it to auto print.

Alternatively you could do a subscription that exports the report to a file and then use a batch print utility to pick up the file and print it.  www.planetpdf.com has  some scripts that might help on this.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now