Friday, February 24, 2012

can an sql procedure start printing a report ?

How can i start printing a report from a trigger activated store procedure ?It's possible.
Basic process:
1. Set up printer delivery extension as described in the books online
(and test that it works nicely)
2. Set up subscription to send required report to printer extension.
3. Go to SQL Agent and find the newly created job. You'll see that the
actual step is just a stored procedure that launches an even in the Report
Server database. Copy --> Paste the step details into the relevant stored
procedure.
"elbert chavarro" wrote:
> How can i start printing a report from a trigger activated store procedure ?

No comments:

Post a Comment