Post reply

Is there a way to determine if reports were created with Report Builder 1.0?

  • June 16, 2016 at 10:51 am

    #308532

    My company is planning to upgrade from SQL Server 2008 R2 to SQL Server 2014. We currently allow clients to create reports with Report Builder 1.0. I would like to find out if there is a way to identify which reports were created with Report Builder 1.0 in order to determine if those reports need to be recreated once the upgrade is complete.

  • June 16, 2016 at 11:43 am

    #1885470

    Tknapik (6/16/2016)

    My company is planning to upgrade from SQL Server 2008 R2 to SQL Server 2014. We currently allow clients to create reports with Report Builder 1.0. I would like to find out if there is a way to identify which reports were created with Report Builder 1.0 in order to determine if those reports need to be recreated once the upgrade is complete.

    Not that I know of, but you can determine who created a report with this query:

    SELECT U.UserName,

    C.[Path],

    C.[Name]

    FROM [dbo].[Catalog] C

    INNER JOIN dbo.Users U ON C.CreatedByID = U.UserID

    GO

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • June 16, 2016 at 11:55 am

    #1885473

    I'm not sure and I can't check right now, but you could look into the report file as xml to find if it's in the metadata.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • June 17, 2016 at 8:28 am

    #1885634

    I haven't really used report models, presumably they have data source deployed on the report manager.

    Could you not just find the data source and use "View Dependent Items"?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply