CSV Pipe export option is not available for default installation of SSRS sharepoint integration mode setup. To enable this option you should edit the configuration file. If you have the multiple WFE server then you have to apply fix on all server. Below script will solve the issue of editing the config file.
Just run the below powershell script in admin mode, It will do the required changes on reporting service application.
$svrDirectives = @"
<OverrideNames>
<Name Language='en-US'>CSV (Pipe Delimited)</Name>
</OverrideNames>
"@
$extConfig = @"
<DeviceInfo>
<FieldDelimiter>|</FieldDelimiter>
<NoHeader>false</NoHeader>
<FileExtension>csv</FileExtension>
<ExcelMode>False</ExcelMode>
<Encoding>ASCII</Encoding>
</DeviceInfo>
"@
$typeName = "Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"
$apps = get-sprsserviceapplication
foreach ($app in $apps)
{
New-SPRSExtension -identity $app -ExtensionType "Render" -name "CSVPipeDelimited" -TypeName $typeName –ServerDirectives $svrDirectives –ExtensionConfiguration $extConfig
}
Similar Topics:
- Adding Ribbon button in Sharepoint 2010
- Benefit and advantages of using Sharepoint
- Automate Sharepoint 2010 installation using AutoSPInstaller
- SharePoint 2010 migration tips
- Microsoft Sharepoint SystemUpdate and Update using object model
- SharePoint 2010 and Powershell
- Learn Sharepoint 14Hive folder structures
- Microsoft Sharepoint updating Author-Created By or Editor field programmatically
- Creating the custom theme in MOSS Branding
- More about SharePoint Custom page and Application Page
