query to retrieve main report and subreport info

Satish 21 Reputation points


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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,784 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points

    Hi @Satish ,
    Unfortunately,the subreports are written in RDL, not directly in SQL Server. Therefore, it is impossible to query the required information.
    Best Regards,

    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.

    0 comments No comments