ActiveReports 13
CSV Provider
ActiveReports 13 > ActiveReports User Guide > Concepts > Page Report/RDL Report Concepts > Data Sources and Datasets > Report Data Source Dialog > CSV Provider

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.

Options in the Configure CSV Data Source wizard Description Example
Path Path to the CSV file - both local and relative; or a URL for centrally located CSV data sources. 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 QualifiersColumn 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
See Also

Walkthroughs