If you have ever needed to extract the .rdl file from SQL Server Reporting Server, it’s not very easy. The physical .rdl (Report Definition List) is not stored anywhere on the server file system. It’s stored in the Catalog table inside Report Server. So, I am sure there are several ways to get this…but I was pressed for time and asked someone that I knew was a lot more knowledgeable on the subject. Steve gave me this link: Reporting Services Scripter
Which has solved all my issues. Now it’s time to give it a run!
#1 by Altini on March 19, 2009 - 10:21 AM
don’t work with sql 2008
#2 by Professor on May 26, 2011 - 9:10 PM
Open this address assuming you have intranet access
//server/Reports
(where ‘server’ is your server name and domain UNC path)
All the reports are there for download, possibly in a folder as set up in the project deploy properties in visual studio.
RDL stands for ‘Report Definition Language’.
#3 by Terry Apodaca on May 26, 2011 - 9:17 PM
yes yes…times have changed since this post…but it still applies to older versions of Reporting Services (SSRS) so there’s no need to remove or change it.
With that said, I do know how things work with Microsoft Reporting and yes I do know you can have server side and client side reports…meaning you can physically place the .rdl or .rdlc file any place you want as long as you point the report viewer correctly to it.
thanks for the input though!!!