Having not touched SharePoint since SharePoint 2013, I was trying to understand what options are available/provided with
SharePoint 2019 in regards to reporting along with
SQL Server 2019.
Is there anywhere with a definitive listing of Report offerings in SharePoint 2019? (or can we add them to this post?)
Whilst previous experience was custom reports via Report Builder - I want to look at report offerings (and visualisations) around lists, tasks, and workflows too.
Previously I've used and installed SSRS along with SharePoint (2010/2013) to allow reports to be created using Report Builder (RDLs) and the RDLs uploaded to SharePoint where they could be viewed.
I've jumped through a lot of articles and am a little confused about what we can do reports-wise in SharePoint 2019.
Confusions for reference
Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
SQL Server Reporting Services - Reporting Services makes it possible to create and share a wide range of powerful reports, including interactive maps, bubble charts, gauges, tables, and other views. Reporting Services report creation tools include Power View (launched from SharePoint Server), Report Designer, and Report Builder.
The Report Viewer web part was available as part of the Reporting Services Add-in for SharePoint products. The web part was specific for report servers in SharePoint integrated mode. SharePoint integrated mode was deprecated after SQL Server 2016.
Starting with SQL Server 2017, there's only one installation mode for Reporting Services: Native mode. You could embed all reports types using a Page Viewer web part using the rs:Embed=true URL parameter. Embedding reports into SharePoint pages is an integration story requested by customers and the updated Report Viewer web part enables this scenario for paginated reports.
Officially SSRS Integrated mode is deprecated in SQL Server 2017 and SharePoint 2019, Now It is not a part of the SQL Server 2017. However, organizations could continue to use SSRS versions 2017 in SharePoint 2019. This is not supported in SharePoint 2019, which means that integrated mode isn’t an option at all with SharePoint 2019. But the good news is, there is some workaround to integrate SSRS 2017 with SharePoint 20149 using the report viewer web part.