I had SQL Server 2008 R2 installed on my laptop and then discovered that the hosting environment for my SSRS reports was SQL Server 2008. Although after reading some articles that indicated compatability might not be an issue unless I used an R2 specific
feature I chose to try the downgrade to avoid any questions of compatability in the future (and am currently regretting that decision).
I am able to create a report but when I chose Preview I get the following error (this same report runs on the SSRS 2008 host server with no issues):
"An error occurred during local report processing. Method 'get_Lookups' in type 'Microsoft.ReportingServices.ReportProcessing.OnDemandReportObjectModel.ObjectModelImpl' from assembly 'Microsoft.ReportingServices.ProcessingCore, Version=10.0.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' does not have an implementation"
I have tried the following:
1) Deinstalled SQL Server 2008 R2, installed SQL Server 2008...got error
2) Then Deinstalled SQL Server 2008, deinstalled Visual Studio 2008, reinstalled SQL Server 2008...get error using the Business Intelligence Studio
3) Renamed the C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll to something else, tried to execute the report from within the BI
View Complete Post