Introduction

After installing K2 blackpoint or K2 blackpearl the SOURCECODE data source in Visual Studio required for designing custom reports is missing.

Error Message

There are no error messages, however the SOURCECODE data source in Visual Studio does not display.

Workaround

The error can be resolved by following the steps below:

Validating the SQL Business Intelligence Development Studio

If you are encountering issues when designing custom reports using the SQL Business Intelligence Development Studio on top of Microsoft Visual Studio, the following configuration must be checked:

  • The assembly SourceCode.Data.SmartObjectsClient.dll must be present in
    • In Visual Studio 2010 - [InstallDrive]\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies
    • In Visual Studio 2012 - [InstallDrive]\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies
    • In Visual Studio 2013 - [InstallDrive]\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies
    • In Visual Studio 2015 - [InstallDrive]\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies

If the DLL is not present, ensure that it is copied there manually

  • In the RSReportDesigner.config file, the following section should be added:
    <Configuration>
    <Extensions>
    <Data>
    <Extension Name="SOURCECODE" Type="SourceCode.Data.SmartObjectsClient.SOConnection,SourceCode.Data.SmartObjectsClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16A2C5AAAA1B130D"/>
    </Data>
    <Designer>
    <Extension Name="SOURCECODE" Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,
    Microsoft.ReportingServices.QueryDesigners"/>
    </Designer>
    </Extensions>
    </Configuration>

Configuration file changes for the K2 for Reporting Services component

If you are encountering issues with the Reporting Services component, validate that the following configuration changes were made to the appropriate files, located in the following folder:

C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer

In the location above, the MSSQL.1 directory depends on the specific environment. The location of the two configuration files described below may then vary depending on where Reporting Services was installed.
  • rsreportserver.config file:
    <Configuration>
    <Extensions>
    <Data>
    <Extension Name="SOURCECODE" Type="SourceCode.Data.SmartObjectsClient.SOConnection,SourceCode.Data.SmartObjectsClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16A2C5AAAA1B130D"/>
    </Data>
    </Extensions>
    </Configuration>
  • rssrvpolicy.config file:
    <CodeGroup class="UnionCodeGroup" version="" Name="CustomDataExtensionCodeGroup" Description="Code group for the Custom Data Extension" PermissionSetName="FullTrust">
    <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL.1\ReportingServices\ReportServer\bin\Sourcecode.Data.SmartObjectsClient.dll"/>
    </CodeGroup>