question

JMs-0144 avatar image
0 Votes"
JMs-0144 asked JMs-0144 answered

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered Isabellaz-1451 edited

Hi @JMs-0144 ,

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.






tab-save.png (109.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JMs-0144 avatar image
0 Votes"
JMs-0144 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.