Auto Printing from SQL Reporting Services
Posted on 2006-10-19
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.