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,798 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    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.

    0 comments