straucha
asked on
Auto Printing from SQL Reporting Services
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.