Progress® Telerik® Reporting R2 2017

Configuring your project for using Microsoft Analysis Services

Before utilizing the CubeDataSource component in your reports you need to configure your report class library for using Microsoft Analysis Services first:

  1. Install the Microsoft ADOMD.NET client data provider: The CubeDataSource component requires the Microsoft ADOMD.NET client data provider to be installed on your machine. The present version of Telerik Reporting is compiled against the ADOMD.NET provider for SQL Server 2008 R2.

  2. Add the required assembly references to your project: You need to add the following assembly references to your report class library:

    • Microsoft.AnalysisServices.AdomdClient - this is the ADOMD.NET client data provider assembly which is normally located in the following directory after installation:

      "<Program Files>\Microsoft.NET\ADOMD.NET\<Product Version>".

      Here "<Program Files>" is the directory with your program files, and "<Product Version>" is the version of the installed product (this should be 100 for ADOMD.NET for SQL Server 2008 R2 ).

    • Telerik.Reporting.Adomd - this is the Telerik Reporting provider assembly for ADOMD.NET which is located in the "Bin" subdirectory of your Telerik Reporting installation.

  3. Add an assembly binding redirect if necessary: The current version of Telerik Reporting uses ADOMD.NET for SQL Server 2008 R2. Please, verify that the version of the Microsoft.AnalysisServices.AdomdClient assembly is "10.0.0.0" . If you have a greater version of that assembly you need to add an appropriate assembly binding redirect in the configuration file of the start application as illustrated below:

    <configuration>
    <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <dependentAssembly>
    <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient"
    publicKeyToken="89845dcd8080cc91"
    culture="neutral" />
    <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535"
    newVersion="<Your Version>" />
    </dependentAssembly>
    </assemblyBinding>
    </runtime>
    </configuration>

    Here "<Your Version>" is the actual version of your Microsoft.AnalysisServices.AdomdClient assembly. In the case of a ClassLibrary project containing report definitions, the binding redirects should be applied in Visual Studio configuration file (devenv.exe.config).