Post reply

Delete SSRS reports

  • July 10, 2017 at 5:05 pm

    #343460

    Hi, I need to delete multiple SSRS reports from report portal. Is there any way to delete them using either rs.exe or any other utilites you might know of? 

    Thanks,
    Tony

  • July 11, 2017 at 6:52 am

    #1950363

    tuand2001@yahoo.com - Monday, July 10, 2017 5:05 PM

    Hi, I need to delete multiple SSRS reports from report portal. Is there any way to delete them using either rs.exe or any other utilites you might know of? 

    Thanks,
    Tony

    Yes, you can use powershell or rs.exe. rs.exe would just call the DeleteItem method.
    In  rs - it would be something like:
    Dim bh As New BatchHeader()
    bh.BatchID = rs.CreateBatch()
    rs.BatchHeaderValue = bh
    RS.DeleteItem("/YourFolder/Report1")
    RS.DeleteItem("/YourFolder/Report2")
    RS.DeleteItem("/YourFolder/Report3")
        
    Try
        rs.ExecuteBatch()
        Console.WriteLine("Reports Deleted")
            
    Catch e As SoapException
        Console.WriteLine(e.Detail.InnerXml.ToString())
            
    Finally
        rs.BatchHeaderValue = Nothing
    End Try

    In Powershell, if you are using the ReportingServicesTools module, you can call Remove-RsCatalogItem. You could also go through the web service if you aren't using the Reporting Services Tools module. You can find an example using the web services in this link:
    How to Install/deploy SSRS (rdl files) using Powershell

    Sue

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

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