question

kumarrr avatar image
0 Votes"
kumarrr asked Joyzhao-MSFT commented

query to retrieve main report and subreport info

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
image.png (7.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
Has your issue been resolved?
If the answer is helpful, please click "Accept Answer" and upvote it.

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

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 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.