SSRS – Unable to preview the report, Install the Business Intelligence Development Studio…

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:

image

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