Has anyone been able to automatically print via reporting services? I have
subscriptions set up that produce PDF files, but I have to go in and manually
print them. There's gotta be a better way.> Has anyone been able to automatically print via reporting services? I have
> subscriptions set up that produce PDF files, but I have to go in and
> manually
> print them. There's gotta be a better way.
I took a long and serious look at this problem and didn't come up with any
snappy solution.
Problems you are facing are mainly the following:
1) Delivering the PDFs to a specific folder, either by manually printing
from the client, or by some automatically scheduled job.
This one I solved with SSIS (Integration Services), which is watching a
"printing command table" in my SQL database, and invoking the report(s)
based on the info from new lines in the table.
Then using a Script task in SSIS, you can invoke the report from SSRS and
get a raw PDF back which SSIS then writes to a PDF file.
2) A PDF printing utility that can be invoked through the command line.
Acrobat reader does NOT handle this from the command line. Some versions of
Acrobat reader are said to handle it via an undocumented commandline switch,
but I found this to be Acrobat version dependent and gave up.
Found a PDF Printing utility from VeryPDF.COM where you can buy a single
server commandline utility for $199
3) Some kind of watching mecanism for the PDF folder which invokes the
PDFPrinting program.
This can be done which ever way you find suitable. It can even be done by
batch file programming, which I did for starters in my implementation.
All in all, a really cumbersome way of delivering reports directly to
printer from a product called "Reporting Services", but it works!
Regards,
Palli
没有评论:
发表评论