In a previous post I showed how to quickly find reports that use custom report items (CRIs). The same idea can be applied to subreports as well. As an administrator of a report server, you may access the catalog database directly. Keep in mind that any queries you execute directly against the report server’s catalog database may affect the performance of the overall system. Make sure that you never take any locks on objects in that database, as this is not supported and interferes with the function of the report server.
The query below runs against the current version of the report server catalog database, and may not necessarily work for future RS versions. It uses XQuery and checks for all three different RDL namespaces since the catalog database stores a copy of the original report in exactly the format it was originally uploaded, so that (maybe several years) later, you can still retrieve exactly the report you published as a 2003/10 or 2005/01 report, even if it is internally on-the-fly upgraded to the latest schema version of the report server it is running on.
Use the following query to get a list of reports that reference subreports, including the path of those subreports:
/* declare and populate temp table */
/* find subreports in RS 2000-based main reports */
/* find subreports in RS 2005-based main reports */
/* find subreports in RS 2008-based main reports */
In a previous posting, I explained the new ExecutionLog2 view in Reporting Services 2008: how to utilize