Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export or download all SSRS 2005 reports in one go without using PowerShell Expand / Collapse
Author
Message
Posted Wednesday, June 4, 2014 7:09 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:42 AM
Points: 14, Visits: 165
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.

Post #1577313
Posted Wednesday, June 4, 2014 7:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
You can try to get it directly out of the reporting database.

Extracting SSRS Report RDL (XML) from the ReportServer database




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1577315
Posted Wednesday, June 4, 2014 7:16 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:42 AM
Points: 14, Visits: 165
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
Post #1577317
Posted Wednesday, June 4, 2014 7:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1577326
Posted Wednesday, June 4, 2014 7:36 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:42 AM
Points: 14, Visits: 165
[/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
Post #1577328
Posted Wednesday, June 4, 2014 7:42 AM This worked for the OP Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1577329
Posted Wednesday, June 4, 2014 9:24 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:42 AM
Points: 14, Visits: 165
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 :)
Post #1577393
Posted Wednesday, June 4, 2014 2:20 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1577533
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse