**IMPORTANT**

Please note that although this currently works when running the queries and report from Visual Studio 2015 Report builder, Dynamics CRM will give you an Error if you try to upload this into CRM. This is due to the slightly different formats of SSDT (which is probably why Microsoft has not released a product for visual studio 2015) You can actually get around that by editing the .rdl files xml, and mimicking that of SSDT 2012. Since many people won't want to do this, I do NOT recommand using this for production use, merely as a learning tool.

How to Install

Copy the Dynamics.CRM.DataProcessing.Extension.dll, Microsoft.CRM.Sdk.Proxy.dll, and the Microsoft.XRM.Sdk.dll files into C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies

Edit the file:

C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config and under the Data node add the line: <Extension Name="Dynamics 365 Data Extension" Type="Dynamics.CRM.DataProcessing.Extension.Dynamics_CRM_Connection,Dynamics.CRM.DataProcessing.Extension"/>

Edit the file:

C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config and add the following code group
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Dynamics365DataExtensionCodeGroup"
Description="Code group for custom data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies\Dynamics.CRM.DataProcessing.Extension.dll" />
</CodeGroup>

Edits that need made to the .rdl file if you want to import it into CRM

I have included 2 sample reports, one with Microsofts Data Provider (Report 2012.rdl) and one with mine (Report 2015.rdl) to see the differences. For ease of use, i have also included an edited 2015 file, and a pdf of the diff.

• Remove the Attribute MustUnderstand="df" and xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily" from the Report Node
• In the Report node, change the xmlns attribute to http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition
• Remove the node <df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily>
• Change the DataProvider from Dynamics 365 Data Extension (Wont Work in CRM...) to MSCRMFETCH
• Remove the nodes ReportSections and ReportSection leaving the Body and all child nodes.
• Remove the nodes ReportParametersLayout and all child nodes.

Now it should import into CRM.