You may receive a System.TypeLoadException exception when you try to preview a report in Report Designer after you install SQL Server 2000 Reporting Services Service Pack 1 (SP1) (873267)

SYMPTOMS

After you install Microsoft SQL Server 2000 Reporting Services Service Pack 1 (SP1), when you try to preview a report that you designed in Report Designer, you may notice that a System.TypeLoadException exception occurs, and you may receive an error message that is similar to the following:

An unhandled exception of type 'System.TypeLoadException' occurred in Microsoft.ReportingServices.Interfaces.dll

Additional Information: Could not load type Microsoft.ReportingServices.Interfaces.CachedDataStatus from assembly Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91.

This problem occurs when you use Report Designer that is available with Microsoft Visual Studio .NET 2003 to design and to preview the report.

You may also receive this error message when you try to deploy the report by using Report Designer.

CAUSE

When you try to preview a report in Report Designer or try to deploy a report by using Report Designer, the common language runtime may try to load the older version of a .dll file from the private assembly cache on your computer instead of the newer version of the .dll file that is available on your computer. Therefore, you receive the error message that is mentioned in the "Symptoms" section.

Note The newer version of the .dll files are installed on your computer when you install Microsoft SQL Server 2000 Reporting Services Service Pack 1 (SP1).

For example, the common language runtime may load the older version of the Microsoft.ReportingServices.Interfaces.dll file that is located in the private assembly cache instead of the newer version of the Microsoft.ReportingServices.Interfaces.dll file that is located in the InstallationDrive\Program Files\Microsoft SQL Server\80\Tools\Report Designer folder.

Note InstallationDrive is a placeholder for the default installation drive on your computer.

WORKAROUND

To work around this problem, empty the private assembly cache on the computer where Report Designer is installed. To do this, follow these steps:

On the computer where Report Designer is installed, locate the assembly folder in the following path:
InstallationDrive\Documents and Settings\%username%\Local Settings\Application Data
Note InstallationDrive is a placeholder for the default installation drive on your computer.
Delete all the files and the subfolders in the assembly folder.

MORE INFORMATION

This problem may also occur after you upgrade the Beta 2 version of Microsoft SQL Server 2000 Reporting Services to the release version of Microsoft SQL Server 2000 Reporting Services.

For more information, see the "Report Designer and upgrading from Beta 2" section in the Microsoft SQL Server 2000 Reporting Services Readme file that is included with SQL Server 2000 Reporting Services.