
I have a Master report and multiple subreports and I need a query to retrieve subreports, sub-report datasets, and stored procedure name of corresponding main report.
Could you please provide a query for this from the report server database?

I have a Master report and multiple subreports and I need a query to retrieve subreports, sub-report datasets, and stored procedure name of corresponding main report.
Could you please provide a query for this from the report server database?
Hi,
Has your issue been resolved?
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @kumarrr ,
Unfortunately,the subreports are written in RDL, not directly in SQL Server. Therefore, it is impossible to query the required information.
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
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.
5 people are following this question.