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: Yesterday @ 9:47 AM
Points: 159, Visits: 688
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
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
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, August 25, 2014 9:55 AM
Points: 1,293, Visits: 1,863
or this
http://www.sqlservercentral.com/Forums/Topic564492-150-1.aspx


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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
...

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
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: Yesterday @ 9:47 AM
Points: 159, Visits: 688
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
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
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: Yesterday @ 9:47 AM
Points: 159, Visits: 688
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