Chapter 24. Creating flexible subscriptions in SSRS

Donabel Santos

If you create reports using SQL Server Reporting Services you may get requests—for example, for specific reports with varying formats and criteria to be emailed out to clients on the fifteenth of every month, or created and stored in a shared folder every Monday. SQL Server Reporting Services (SSRS) supports subscriptions but can be inflexible and rigid. PowerShell can help IT and SQL Server professionals with flexible report scheduling and delivery that support dynamic parameters and ever-changing user requirements.

In this chapter we’ll look at implementing something similar to a data-driven subscription using a list in a CSV file and PowerShell. What I’ll show you is just ...

Get PowerShell Deep Dives now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.