SharePoint BI - How to fix SSRS Issues
SQL Server Reporting services can be used and configured in Integrated Mode and Native mode as well. There are some noticeable differences between both modes. SSRS in SharePoint Integrated Mode: • Use SharePoint document management and collaboration features. A SharePoint site provides a unified portal for accessing and managing all documents in one place. • Use SharePoint permissions and authentication providers to control access to reports, models, and other items. • Manage reports, models, data sources, schedules, and report history in custom application pages on a SharePoint site. We can set properties, define schedules and subscriptions, and create and manage report history on a SharePoint site the same way you create and manage them from other tools in SQL Server. • Publish or upload reports, report models, resources, and shared data source files to a SharePoint library, including Report Center in Offic...