Post reply

Renaming SSRS reports programmatically

  • September 30, 2020 at 1:47 pm

    #3791942

    Hello experts,

    I used one of the RS scripting tools to export some reports from on SSRS server in order to import them on another server.

    The reports were exported with rdl names along the lines of

    -MyFolder-MyReport.rdl

    There are hundreds of reports. I ended up manually creating the folders and putting the reports into the corresponding folders. So the actual report names are now along the lines of -MyFolder-MyReport.

    Does anyone know if there is a way to rename this reports with T-SQL or other code to replace 'MyFolder-' with ''? Otherwise I will have to rename them all by hand.

    Thanks for any help.

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • September 30, 2020 at 4:10 pm

    #3792009

    If you wanted to look at doing this programmatically, you could use the Web Services API. There is an article up here that walks through how to do that:

    Bulk Move/Rename of SSRS Reports through Web Services

    Sue

  • October 5, 2020 at 1:40 pm

    #3792876

    Thank you! I'll check that link.

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

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

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