Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RS in Sharepoint integrated mode and semicolon as export file field delimiter Expand / Collapse
Author
Message
Posted Wednesday, April 3, 2013 7:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 13, 2014 2:56 AM
Points: 22, Visits: 153
First a bit ambigious on wether to ask for a new Sharepoint Topic group, or posting this question in RS or SQL 2012 groups, what's your opinion?

Anyway, I stumbled upon the need to change the CSV export file default behaviour to use comma (",") as the field delimiter, and instead use another sign (here: semicolon (";") but from other forum sites I have spotted need for the [TAB] sign as well as the [SPACE] sign).

In old 2008 RS server I found and changed the rsreportserver.config file found in \MSSQL\MSRS10.MSSQLSERVER\Reporting Services\ReportServer Folder (and not in the subfolder \BIN as stated in MS documentation) from:

<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>

to:

<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<Configuration>
<DeviceInfo>
<FieldDelimiter>";"</FieldDelimiter>
</DeviceInfo>

</Configuration>
</Extension>

and it worked as wanted.

But where do I do the same change in an Sharepoint 2010 RS 2008 R2 integraded server (where the SQL Server i separate from the webserver)?

I found the RSreportserver.config at the SQL Server instans server in a quite different folder location: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Reporting\

And also - that file is quite different from the one in RS 2008 and doesn't have the CSV Extension attribute at all. Could I just add the whole shabang?

Post #1438324
Posted Wednesday, June 11, 2014 7:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 16, 2014 12:43 AM
Points: 1, Visits: 1
Hello, Jonas.

You need use powershell to change configuration in that case. Like in this article http://msdn.microsoft.com/en-us/library/gg492249(SQL.110).aspx
You need update ConfigurationXml to something like that:
<DeviceInfo>
<FieldDelimiter xml:space='preserve'>;</FieldDelimiter>
</DeviceInfo>


Post #1579627
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse