query to retrieve main report and subreport info

Satish 21 Reputation points
2021-04-29T15:09:09.643+00:00

92681-image.png

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,132 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2021-04-30T08:37:55.85+00:00

    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,
    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.

    No comments