Automate SSRS Report Generation using PowerShell

This blog post is tested on SQL Server 2014 and PowerShell V5. PowerShell has become more feature-rich in every version. We are now looking at PowerShell V5 (currently can be downloaded as part of Windows Management Framework v5 April 2015 Preview). The support landscape with SQL Server hasn’t changed much. There isn’t a drastic increase…


Discovering SSRS Report Parameters using PowerShell

We can use PowerShell to discover many SSRS properties, including the different parameters available in a report. This blog post is based on SQL Server 2014 and PowerShell V5. Here is an example: This particular report utilizes different variations of parameters. To review, here are the available data types for SSRS report parameters: In the…