O'Reilly logo

PowerShell Deep Dives by Edited by Jeffery Hicks, Richard Siddaway, Oisín Grehan, and Aleksandar Nikoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required