can't retrieve RDL from report server 2005?

Question

Post reply

can't retrieve RDL from report server 2005?

cafescott

SSCarpal Tunnel

Points: 4724
More actions
June 3, 2014 at 11:46 am

#308758

Jeez Louise, I can't believe the difficulty of this task!! I made changes to a report and deployed them to our report server. However, the changes are not in TFS. I overwrote my changes from TFS. Now I am banging my head against the wall trying to get the RDL out of report server.
I've looked here:
http://www.sqlservercentral.com/Forums/Topic965586-147-1.aspx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102320
http://social.msdn.microsoft.com/forums/sqlserver/en-US/df191498-9b45-413e-bc1b-32944ac02701/how-to-download-reports-from-reportserver
http://sql-articles.com/articles/general/download-export-rdl-files-from-report-server/
When I visit Report Manager, my URL looks like this:
http://XX.XXX.XX.XX/ReportServer/CompanyReports
I have a list of report names. If I right-click the one I want, I can "save target as". The only problem is it is saving an HTML file, not the RDL file that I need.
Right-click on the report, then properties, opens up a dialog with no other options besides OK/Cancel.
Did Microsoft really make it impossible to retrieve a report from Report Server 2005? This is super frustrating.
Any help appreciated. Thanks.

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Try this article.

http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

AlexSQLForums SSChampion Points: 14277 More actions · Answer 2

or this

http://www.sqlservercentral.com/Forums/Topic564492-150-1.aspx

Alex S

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

...

This was in error.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

cafescott SSCarpal Tunnel Points: 4724 More actions · Answer 4

Thanks for the speedy replies. The problem seems to be that I am not in Report Manager. I've just asked someone I work with how to get there.

I have a list of file names, but don't have any ability to download them. If I get to the Report Manager with the yellow background then hopefully it will work.

Thanks,

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Good luck. Looking at it, yeah you were only in Report Server. You need to be in Report Manager to download. Or download from the database like in the link I provided.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

cafescott SSCarpal Tunnel Points: 4724 More actions · Answer 6

Thanks again, SQLRNNR. I think the link you posted is very cool. Someday I will need to create an SSIS package that downloads all the reports.

Thanks Alex, for your link. This is what saved me.