I have been using Microsoft SQL Server 2014 with Visual Studio 2010 to create SSRS reports for Dynamics AX 2012. When I tried to preview a report in the designer, the following error was displayed:
The error message was a little confusing as SQL Server 2014 does not include the Business Intelligence Development Studio (BIDS) component that came with previous SQL Server releases. Instead, there is a replacement add-on called “SQL Server Data Tools – Business Intelligence” (SSDT-BI), which has to be downloaded separately as this is not part of the SQL Server 2014 installation media.
SSDT-BI can be downloaded for free from https://msdn.microsoft.com/en-us/hh297027.aspx.
You can install the BIDS component from SQL Server 2008, which also works, but it is recommended you try installing the SSDT-BI