Issue in custom datasource execution in SSRS 2012

• ansuman2006

  SSC Eights!

  Points: 987

  More actions

  October 16, 2015 at 2:38 am

  #301506

  I am suing SQL Server Data Tools 2012 and I have build a new custom DLL in C# and with an objective to use the DLL to execute by calling it within the SSRS report RDL. For this I have modified two file RSPreviewPolicy.config and RSReportDesigner.config with the following modifications,

  RSPreviewPolicy.config : -

  <CodeGroup

  class="UnionCodeGroup"

  version="1"

  PermissionSetName="FullTrust"

  Name="Customer_DataSource"

  Description="Code group for my Custom DataSource for data processing extension">

  <IMembershipCondition

  class="UrlMembershipCondition"

  version="1"

  Url="C:\Program Files\Microsoft Visual Studio 11.0\Common7\

  IDE\PrivateAssemblies\DataSourceExtension.dll"

  />

  </CodeGroup>

  RSReportDesigner.config :-

  <Configuration>

  <Add Key="SecureConnectionLevel" Value="0" />

  <Add Key="InstanceName" Value="Microsoft.ReportingServices.PreviewServer" />

  <Add Key="SessionCookies" Value="true" /> <Add Key="SessionTimeoutMinutes" Value="3" />

  <Add Key="PolicyLevel" Value="rspreviewpolicy.config" />

  <Add Key="CacheDataForPreview" Value="true" />

  <Extensions>

  <Render>

  .........................

  .........................

  </Render>

  <Data>

  .........................

  .........................

  <Extension Name="CUSTOM_DATASOURCE"

  Type="DataSourceExtension.DataSetConnection, DataSourceExtension" />

  </Data>

  <Designer>

  ........................

  ........................

  <Extension Name="CUSTOM_DATASOURCE" Type="Microsoft.ReportingServices.

  QueryDesigners.GenericQueryDesigner,

  Microsoft.ReportingServices.QueryDesigners"/>

  </Designer>

  </Extensions>

  </Configuration>

  This above setup works exactly fine for SSRS 2008R2 version but when the same thing is being used for SSRS 2012 it is throwing an error as "An attempt has been made to use the extension CUSTOM_DATASOURCE that is either not registered for this report server or not supported for this version of Report Services".

  Can anyone of you please help me and let me know if anything else needs to be done from the setup perspective.