共用方式為


CSV Device Information Settings

The device information settings for the CSV rendering extension allow delimiters and qualifiers to be changed and line break handling to be specified. The extension of the file can also be submitted, as well as the encoding and inclusion of header rows in the output. Because delimiters are likely to be special characters, you should encode them in a CDATA section, if the settings are written as XML.

The following table lists the device information settings for rendering in Text format.

Setting Value

Encoding

One of the character encoding schemas: ASCII, UTF-7, UTF-8, or Unicode. The default value is Unicode.

Extension

The file extension to put on the result. The default value is .CSV.

FieldDelimiter

The delimiter string to put in the result. The default value is a comma (,). You should URL encode the value of this device information when passing it on a URL. For example, a tab character as a delimiter should be "%09".

NoHeader

Indicates whether the header row is excluded from the output. The default value is false.

Qualifier

The qualifier string to put around results that contain the field delimiter or record delimiter. If the results contain the qualifier, the qualifier is repeated. The Qualifier setting must be different from the FieldDelimiter and RecordDelimiter settings. The default value is a quotation mark (").

RecordDelimiter

The record delimiter to put at the end of each record. The default value is <cr><lf>.

SuppressLineBreaks

Indicates whether line breaks are removed from the data included in the output. The default value is false. If the value is true, the FieldDelimiter, RecordDelimiter, and Qualifier settings cannot be a space character.

請參閱

參考

Reporting Services Web Services Class Library
Render

概念

Reporting Services Device Information Settings

其他資源

在組態檔中指定轉譯延伸模組參數

說明及資訊

取得 SQL Server 2005 協助