Home Forums Reporting Services Reporting Services 2008/R2 Administration How to get a list of SubReports RE: How to get a list of SubReports

  • April 13, 2015 at 12:30 pm

    #1790612

    this worked for me:

    /*--results

    t Name="DistributionCoderPerHour"><ReportName>Code...lots of XML follows

    t Name="DistributionDataEntryPerHour"><ReportName>Da...lots of XML follows

    */

    WITH MyCTE

    AS

    (

    select convert(varchar(max),CONVERT(varbinary(max),Content))As StrContent,*

    from ReportServer$MSSQLSERVER1.dbo.Catalog

    --where name ='CPU - Dynamics UpLoad'

    )

    SELECT SUBSTRING(StrContent,p1.i + 9,p2.i - p1.i),* FROM MyCTE

    CROSS APPLY(SELECT CHARINDEX('<SubReport',StrContent) As i) p1

    CROSS APPLY(SELECT CHARINDEX('</SubReport>',StrContent) As i) p2

    WHERE CHARINDEX('<SubReport',StrContent) > 0

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!