Get SQL Server 2012 SSRS Report Rendering Extensions Using PowerShell

Written by belle
Posted August 25, 2012 at 8:58 am

There are new rendering extensions supported in SSRS 2012. Welcome extensions are the OPENXML rendering formats, to be used with Word 2007/2010 (.docx) and Excel 2007/2010 (.xlsx).

To list the rendering extensions, you can use the ReportViewer from the Reporting Services Redistributable Package.
You can download from here
http://www.microsoft.com/en-us/download/details.aspx?id=6442

 
[System.Reflection.Assembly]::Load("Microsoft.ReportViewer.WinForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91") | Out-Null
 
$ReportServer = "http://KERRIGAN:80/ReportServer"
$rv = New-Object Microsoft.Reporting.WinForms.ReportViewer
$rv.ProcessingMode = "Remote"
$rv.ServerReport.ReportServerUrl = $ReportServer
$rv.ServerReport.ListRenderingExtensions()

This should list all the currently supported extensions. In SSRS 2012 they are listed below. Note that both Word 2003 and Excel 2003 are technically still supported, but by default they are hidden from the export dropdown. The Excel and Word that we see in the export dropdown is the EXCELOPENXML and WORDOPENXML formats, which corresponds to the new .xlsx and .docx extensions.

Name	LocalizedName	Visible
XML	XML file with report data	True
NULL	NullRenderer	False
CSV	CSV (comma delimited)	True
ATOM	Data Feed	False
PDF	PDF	True
RGDI	Remote GDI+ file	False
HTML4.0
MHTML	MHTML (web archive)	True
EXCEL	Excel 2003	False
EXCELOPENXML	Excel	True
RPL	RPL Renderer	True
IMAGE	TIFF File	True
WORD	Word 2003	False
WORDOPENXML	Word	True