Import All SSRS Reports from SSRS Server into Microsoft Visual Studio Community 2019 Version 16.11.2

JM12377 196 Reputation points
2021-09-16T23:18:26.363+00:00

We would like to import all SSRS Reports from a specific Folder into a VS 2019/Team Project automatically. Is there anyway to do this ? We know how to do this individually, but with a few hundred reports, we would like to do this automatically, if possible.
Thank you

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
0 comments No comments
{count} votes

Accepted answer
  1. Isabellaz-1451 3,616 Reputation points
    2021-09-17T05:24:41.637+00:00

    Hi @JM12377 ,

    Automatically import all reports from SSRS server into a VS project is impossible ,but you can download all SSRS reports .

    Please refer to this link: https://stackoverflow.com/questions/46783093/download-all-ssrs-reports

    You can use this statement to generate download links for all reports in the ‘sale’ folder

    SELECT 'http://mySQLServerName/reports/api/v2.0/catalogitems(' + cast(itemid as varchar(256))+ ')/Content/$value' AS url  
            FROM Catalog WHERE Type IN(2,5) AND Path LIKE '%/Sales/%'   
    

    and then in tab save extention download them all at once

    132995-tab-save.png

    Best Regards,
    Isabella


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our [documentation][10] to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 42,926 Reputation points
    2021-09-17T05:56:52.063+00:00

    Create a SSRS project, right-mouse click on the project => Add => Existing elements => Mark all report and go.

    0 comments No comments

  2. JM12377 196 Reputation points
    2021-09-17T15:23:52.35+00:00

    Thank you both - the above two responses and answers are helpful to the resolution.

    0 comments No comments