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!