Adding Custom SSRS Export Formats in Sharepoint Integrated Mode

What I needed: To add tab delimited and no header csv output to Reporting Services integrated mode in Sharepoint 2013.

What I did: Obligatory google-fu, synthesized what others had done.

Solution:
Powershell script as follows:

#enable sharepoint powershell

$ver = $host | select version

if($Ver.version.major -gt 1) {$Host.Runspace.ThreadOptions = "ReuseThread"}

if(!(Get-PSSnapin Microsoft.SharePoint.PowerShell -ea 0))

{

Add-PSSnapin Microsoft.SharePoint.PowerShell

}

##

#Set Script Variables

##

#Remeber: Must run shell as administrator, I used my farm account.

#Get App GUID

$AppGUID = Get-SPRSServiceApplication

#delete tab extension

Remove-SPRSExtension -identity $AppGUID -name "TAB" -ExtensionType "Render"

#Add Tab delimited output to SSRS

New-SPRSExtension -identity $AppGUID -ExtensionType "Render" -name "TAB" -TypeName "Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering" -ServerDirectives "<OverrideNames><Name Language='en-US'>TAB Delimited</Name></OverrideNames>" -ExtensionConfiguration "<DeviceInfo><Encoding>ASCII</Encoding><FieldDelimiter xml:space='preserve'>`t</FieldDelimiter><UseFormattedValues>False</UseFormattedValues><NoHeader>True</NoHeader><FileExtension>txt</FileExtension></DeviceInfo>"

#delete extension

#Remove-SPRSExtension -identity $AppGUID -name "CSV (No Header)" -ExtensionType "Render"

#Add CSV no header

New-SPRSExtension -identity $AppGUID -ExtensionType "Render" -name "CSV (No Header)" -TypeName "Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering" -ServerDirectives "<OverrideNames><Name Language='en-us'> CSV No Header</Name></OverrideNames>" -ExtensionConfiguration "<DeviceInfo><Encoding>ASCII</Encoding><UseFormattedValues>False</UseFormattedValues><NoHeader>True</NoHeader><FileExtension>csv</FileExtension></DeviceInfo>"

#Lets see our new report extension

Get-SPRSExtension -Identity $AppGUID -ExtensionType Render

Sources:
https://blog.westmonroepartners.com/configuring-custom-render-formats-sql-server-reporting-services-sharepoint-integrated-mode/

http://charanmandya.blogspot.com/2014/06/export-csv-without-header-in-ssrs.html