North Texas SQL Servers Users Group

Next Meeting: Thu, Jun 15 2017

NTSSUG 15 JUN 2017


Managing SSRS Reports
Using PowerShell and SSRS Web Services

By Russ Loski 

Summary: When you have to do something more than once, you should script it!  That’s true for SQL Server maintenance tasks.  It’s also important for Business Intelligence projects as well.  Microsoft has provided web services to manage your reporting service and to download reports in various forms.  In this session I demonstrate how to leverage these web services from PowerShell to handle common SSRS administrative tasks:  uploading and copying a report; checking the parameter values, setting the parameter defaults, scheduling a cache refresh.  I addition, I demonstrate how to download a report top PDF using PowerShell.  You will not only come away with a set of PowerShell scripts to manage your SSRS server, you will learn how to work around some of the less intuitive features of PowerShell to use and extend these scripts. 

Presenter: Russ Loski

Bio: Russ is the Director of Finance of the North Texas SQL Server User Group.  He began developing database applications beginning with SQL Server 6.5.  For much of the last 15 years he has worked as a contract database and ETL developer for various companies in Dallas Fort Worth and Bermuda.  His clients has included the Dallas Cowboys, Rave Motion Pictures and Bank of America.  Currently he works for Baylor Scott & White.  Russ blogs occasionally at  You can follow him on Twitter @sqlmovers.

Meeting starts: 6:00 pm with food and a QA session

Presentation: 6:30 pm to 7:30 pm

Microsoft Las Colinas Offices  
7000 North Highway 161 , Building LC-1  
Irving Texas 75039  

Afterward socializing: If there is interest, we will gather at NYLO (1001 W Royal Ln, Irving, TX 75039) to casually socialize

Back to Top