Export or download all SSRS 2005 reports in one go without using PowerShell

Question

Post reply

Export or download all SSRS 2005 reports in one go without using PowerShell

Ronnie Rahman

Say Hey Kid

Points: 674
More actions
June 4, 2014 at 7:09 am

#289507

Dear All,
As PowerShell script is not allowed, are there any other methods or ways to export or download all SSRS 2005 reports without using PowerShell please.
Many Thanks in advance.

Viewing 8 posts - 1 through 7 (of 7 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

You can try to get it directly out of the reporting database.

Extracting SSRS Report RDL (XML) from the ReportServer database[/url]

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ronnie Rahman Say Hey Kid Points: 674 More actions · Answer 2

Hiya

Thank you very much for your quick response.

I will check the link you have provided. The main requirement is to download report file as pdf format in one go.

Many Thanks

Ronnie

Koen Verbeeck (6/4/2014)
You can try to get it directly out of the reporting database.
Extracting SSRS Report RDL (XML) from the ReportServer database[/url]

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Ronnie Rahman (6/4/2014)
Hiya
Thank you very much for your quick response.
I will check the link you have provided. The main requirement is to download report file as pdf format in one go.

Do you want the reports rendered as PDFs, or do you want the report code?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ronnie Rahman Say Hey Kid Points: 674 More actions · Answer 4

[/quote]

Do you want the reports rendered as PDFs, or do you want the report code?[/quote]

Yes please - report rendered as PDFs. Currently we are saving reports as PDF files one by one, which is tedious and painful process.

Many Thanks

Ronnie

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Ronnie Rahman (6/4/2014)
Yes please - report rendered as PDFs. Currently we are saving reports as PDF files one by one, which is tedious and painful process.

In that case, skip the article I linked to 🙂

You could write .NET code that goes to the SSRS webservice and downloads all of the reports as PDFs.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ronnie Rahman Say Hey Kid Points: 674 More actions · Answer 6

Koen Verbeeck (6/4/2014)
Ronnie Rahman (6/4/2014)
Yes please - report rendered as PDFs. Currently we are saving reports as PDF files one by one, which is tedious and painful process.
In that case, skip the article I linked to 🙂
You could write .NET code that goes to the SSRS webservice and downloads all of the reports as PDFs.

Thank you mate for pointing towards the right direction - sounds like fun 🙂

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

Ronnie Rahman (6/4/2014)
Koen Verbeeck (6/4/2014)
Ronnie Rahman (6/4/2014)
Yes please - report rendered as PDFs. Currently we are saving reports as PDF files one by one, which is tedious and painful process.
In that case, skip the article I linked to 🙂
You could write .NET code that goes to the SSRS webservice and downloads all of the reports as PDFs.
Thank you mate for pointing towards the right direction - sounds like fun 🙂

No problem, I hope it all works out.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP