VS Crashes If Microsoft Report Viewer Is Used When Designing Local Reports and Adding Datasets
Environment
| Product | Progress® Telerik® UI for ASP.NET AJAX |
Description
Visual Studio crashes if the project uses Microsoft Report Viewer when designing a local report (.rdlc) and adding a dataset.
Error Message
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified
Cause
You are required to refer the Microsoft.AnalysisServices.AdomdClient assembly with the Version=10.0.0.0 specific version. If this assembly is not referenced by the solution or is not present in the GAC of the machine, Visual Studio cannot find it and it crashes. The required version comes with Microsoft SQL Server 2008 R2 SP2 Feature Pack, but the Microsoft SQL Server 2012 Feature Pack will install the Microsoft.AnalysisServices.AdomdClient assembly with Version=11.0.0.0 and later versions are also available.
Solution
Ensure that the machine has Microsoft.AnalysisServices.AdomdClient Version=10.0.0.0 on it by installing the free Microsoft SQL Server 2008 R2 SP2 Feature Pack from https://www.microsoft.com/en-us/download/details.aspx?id=30440.
You need only the following components from the available list. Make sure to select the correct processor architecture for your machine:
SQLSERVER2008_ASADOMD10SQLSERVER2008_ASAMO10
Client reports indicate that for Telerik versions Q1 2016 and later on Windows 10, you also need to reference the Telerik.Web.Spreadsheet.dll assembly in your project.