November 28, 2006 at 10:24 am
I've got my first working Reporting Services report. I want to make it print out every other week on Thursday morning. I've gotten into my report in RS's Report Manager. I've clicked on the New Subscription button, which then took me to another page to fill out the parameters, specify the schedule that it is supposed to run, etc. But it also asked for a delivery mechanism for the report and it gave me only one option which is Report Server File Share. I want my report to print to a printer once every other week, not go to a file. Is the only way to make it print to a printer is to first go to a file? And if so, what format?
Kindest Regards, Rod Connect with me on LinkedIn.
November 29, 2006 at 10:00 am
Whose printer would it go to, and how would they know it was there?
What we've done is turned the Report Server E-Mail capability on ( no, I don't know how, that's our tech staff), and then we email the reports to the recipient(s). On the subscription setup page, you can select the file format with "Render Format" (under the Subject line for email, or under the Path line for your current situation). We tend to use Excel or PDF formats here for people-readable reports, but we do have a few files we create in CSV format as well.
Steph Brown
February 14, 2007 at 11:13 am
What I did...I set up delivery to a file share as PDF, then had a vb app print the report from the file share. That worked great for several months, then all of a sudden the agent job would say it ran, but it didn't. So now, I have to print them every morning. I tried installing the printer delivery sample from MS, but it will only print portrait...and of course my reports are landscape. I'm still working on this, but not getting anywhere. The sample is only in C# as of now also. Another thing to consider...every time the report is deployed to the file share, it will overwrite the existing report, unless you set up automatic renaming. Good Luck!
February 14, 2007 at 12:35 pm
It sounds like Rod is describing 2005 Reporting Services subscription features and the product out of the box enables email and file share subscriptions, but out of the box no print subscriptions.
February 15, 2007 at 10:28 am
Yeah, SSRS is meant more for orgs that have a development staff that can build onto it. It is not meant as a turnkey solution except for the simplest of reporting requirements.
That said, I'm sure there are third-party products out there that can easily add the ability to print via subscription. I just wish I could find one..
..jeremy.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply