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

can't retrieve RDL from report server 2005? Expand / Collapse
Author
Message
Posted Tuesday, June 3, 2014 11:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 12:35 PM
Points: 146, Visits: 648
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.


Post #1577081
Posted Tuesday, June 3, 2014 11:48 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:59 PM
Points: 21,297, Visits: 14,988
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1577082
Posted Tuesday, June 3, 2014 11:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 28, 2014 8:13 AM
Points: 1,288, Visits: 1,847
or this
http://www.sqlservercentral.com/Forums/Topic564492-150-1.aspx


Alex S
Post #1577084
Posted Tuesday, June 3, 2014 11:55 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:59 PM
Points: 21,297, Visits: 14,988
...

This was in error.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1577085
Posted Tuesday, June 3, 2014 11:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 12:35 PM
Points: 146, Visits: 648
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,
Post #1577087
Posted Tuesday, June 3, 2014 12:05 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:59 PM
Points: 21,297, Visits: 14,988
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1577091
Posted Tuesday, June 3, 2014 12:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 12:35 PM
Points: 146, Visits: 648
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.


Post #1577098
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse