The CSV Data Provider supports following option under the Connection section in Report Data Source dialog.

Connection String

The CSV connection string is generated on the basis of options selected in the Configure CSV Data Source wizard.

Option	Description	Example
File Path	Path to the CSV file (both local and relative).	C:\Categories.csv
Encoding	Encoding of the CSV file.	Unicode (UTF-7)
File Type	The type of CSV file. You can choose from Fixed and Delimited options.	Delimited
Text Qualifiers	Symbol to specify where the text begins and ends. You can choose from Quotes and Single quotes options.	Quotes
Column Separator	Symbol to separate the columns. You can choose from Comma, Semicolon, Tab, and Space options.	Semicolon
Treat consecutive as one	Specify whether to join the column separators or row separators as one.	Checked for Column separator Unchecked for Row Separator
Locale	Specify the locale.	English (United States)
Starting Row	Row number to start fetching data.	0
Columns have headers	Specify whether the CSV file has columns with headers or not.	Checked
Row Separator	Symbol to separate the rows. You can choose from CRLF (carriage return and line feed), CR (carriage return), and LF (line feed) new line formats.	New line (CRLF)
Get from preview	Fills the Columns area with names and data types (string by default) for columns present in csv file. This allows you to modify the name and data type (as String, Boolean, Date Time, Integer, or Float) for the columns.	ClaimAmt(Float), SvcDate(DateTime)
Note: Text Qualifiers, Column Separator, Row Separator, and Treat Consecutive as one options are not available for Fixed file type.

For example, the following connection string is generated based on the options selected in the Example column above.

Path=C:\\Categories.csv;Encoding=utf-7;Locale=en-US;TextQualifier=";ColumnsSeparator=\;;RowsSeparator=\r\n;
Columns=EmployeeID,LastName,FirstName,Role,City;JoinColumnsSeparators=True;HasHeaders=True