December 27, 2016 at 12:43 am
Hi,
Is there an option to print a report directly. instead of the default that the report open as pdf and then i can print it.
Thanks.
December 29, 2016 at 3:45 am
This isn't a feature in 2012, and although I've not experimented as much with 2016, I don't recall hearing that it has become an option. The msdn page makes no mention of it in the subscription delivery options.
I've had a Google, and there's an article about using an asp.net webform to try and achieve this, here: https://www.codeproject.com/kb/reporting-services/rsclientprint.aspx
Alternatively, you could use SSIS. You would need to fire the subscription to save the file to a known location, wait for the subscription to be completed(it is up to you how you do this, such as checking the subscription status, checking the file exists (you would need to delete any prior versions for this method), etc) and then invoke the application that would open it to print it.
For example, for a PDF, you would invoke command along the lines of:
"C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRD32.exe" "Z:\SSRS\AutoPrints\MyReport.pdf" "/p"
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply