Take Another Look at CSV Rendering in RS 2008

 

Take Another Look at CSV Rendering in RS 2008

If you used the CSV renderer in previous releases of Reporting Services, you might want to take another look in RS 2008.  We listened to your feedback: not only does CSV rendering consume significantly less resources and is faster in most cases, the CSV data output is generally more useful as well if you use complex report layouts (e.g. matrix).

As in previous releases, the CSV renderer output is customizable via device info settings and the data output is controlled by the DataElementOutput setting on reportitems and groups.  For more information about report design considerations for CSV check the documentation.

One common question I have seen related to CSV output is how to configure different field or record delimiters.  We improved this in RS 2008 so that you can specify special characters, such as tab or newline, directly in the report server's configuration file (RSReportServer.config).  For example, to configure ASCII encoding and tab field delimiters use the following settings:

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

<Configuration>

<DeviceInfo>

<Encoding>ASCII</Encoding>

<FieldDelimiter>&#09;</FieldDelimiter>

</DeviceInfo>

</Configuration>

</Extension>

Note: when using a server-wide device info configuration, special characters used as delimiters should be specified encoded.

Posted: Tuesday, January 20, 2009 9:30 PM by Robert M. Bruckner

Robert Bruckner's Advanced Reporting Services Blog : Take Another Look at CSV Rendering in RS 2008