With the recent release of SQL Server 2016, Microsoft has also announced that the next version of SQL Server will no longer have an integrated mode for SQL Server Reporting Services (SSRS). Supporting only a native mode installation in the next version, Microsoft intends to simplify the installation and management of SSRS and provide more capabilities for users. Some of these capabilities include a modern web portal, paginated reports, mobile reports, and KPIs, regardless of if you have SharePoint, as well as simpler architectures, better options for upgrade management, and more targeted performance management.
This new direction from the SSRS team does not mean that SharePoint is going to be without SSRS integration. Instead, users will be given the choice to integrate with SharePoint, and the process to integrate a report into SharePoint will be simpler. The new installation will include the abilities to embed reports in SharePoint pages, report on data in SharePoint lists, and deliver reports to SharePoint libraries, providing a close link between SSRS and SharePoint without the confusion and complications that arose with previous versions. The possibilities for the integration of SharePoint and SSRS are by no means over, but these two systems will now be able to work together in a more streamlined and simplified fashion, making the future for their use bright.
For further information on this development, see these additional resources:
• Simplifying our SharePoint integration story – SQL Server Reporting Services Team Blog
• The Future of Report Integration with SharePoint – John White