In SQL Server Reporting Services (SSRS) 2005 there are a whole host of new features. This means that reports that are developed in Visual Studio 2005 AKA the “SQL Server Business Intelligence Development Studio” cant be deployed to SQL Server 2000 Report Servers or opened in Visual Studio 2003.
Unfortunately that is just what a colleague of mine needed to do.
Fortunately I remembered reading somewhere, cant find the reference now, that with a bit of a hack it can be done. BUT ONLY FOR BASIC REPORTS!
What you need to do is open the .RDL file in a text editor and change the XML.
The First node needs to be changed to read:
Then do a search for “Interactive” You should find 2 nodes InteractiveWidth and InteractiveHeight. You need to delete these nodes.
I have found that reports then work.
NOTE. This is not an approved, supported or condoned by anyone. Do it at your own risk and take backups!