Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Auto Printing from SQL Reporting Services

Posted on 2006-10-19
1
Medium Priority
?
349 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 14

Accepted Solution

by:
simon_kirk earned 1500 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
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.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 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