Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Chapter 21Content Management

WHAT'S IN THIS CHAPTER?

• Using web portal
• Content management activities
• Item-level security
• Content management automation

In this chapter, we explore the management of Reporting Services content. Reporting Services content includes:

• Reports
• Mobile reports
• KPIs
• Shared data sources
• Shared datasets
• Report resources
• Shared schedules

In Native mode, Reporting Services content management is performed primarily through the Web Portal application. Additionally, some administrative tasks may be managed in SQL Server Management Studio (SSMS). Scripts executed through the RS utility provide an alternative means of performing these tasks.

NOTE

A set of PowerShell commandlets, which essentially duplicate some of the RS utility features, were introduced for Reporting Services; as of this writing, they are still in preview. Check for an update by searching for SSRS PowerShell Provider on CodePlex.com. With efforts to expand PowerShell support for Reporting Services by the community and the product team, I suspect that a comprehensive set of commandlets will be available in the near future, if not by the time you read this book.

In SharePoint Integrated mode, content management activities are performed in a similar manner but through the SharePoint site or through the ReportServer web services endpoint. In this mode, Web Portal and the RS utility are unavailable.

USING WEB PORTAL

Web Portal is the primary content management tool for Reporting Services ...