question

NishchalG-5579 avatar image
0 Votes"
NishchalG-5579 asked NishchalG-5579 commented

Execute SSRS report from SQL SERVER stored procedure.

Hello :),

I tried to search the forum but I could not find the solution.

I have a SSRS report which works fine. Can I call it From a Stored Procedure ?

Thanks,
Warm Regards,
Nishu.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered NishchalG-5579 commented

Hi @NishchalG-5579,

What do you mean of call the report from a Stored Procedure?

If you want to render a SSRS report to PDF using TSQL/stored procedure, you may use the Reporting Services web services to render a report to PDF format. We are able to use CLR stored procedure to call a web services.

Take a reference here.

If you want to create a subscription of the report, you may set the subscription as an agent job which can also be started from stored procedure.

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello Zoehui-MSFT ,

Thanks Zoehui-MSFT. That is what I want to do.

Reagrds
Nishu

0 Votes 0 ·