Hi @NishchalG ,
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.