New to Telerik Reporting? Download free 30-day trial

CsvDataSource Wizard of the Report Designer

The CSV Data Source Wizard allows you to create a new or edit an existing CsvDataSource component based on several settings. After the wizard appears you have to perform the following steps:

  1. Choose a CSV Source Choose between file or inline string

    Choose a CSV Source dialog of the CsvDataSource Wizard of the Report Designer

  2. Configure the Separators Check at least one separator from each list. Check the consecutive field/record separators option (or both) if empty fields/records have to be omitted.

    Configure the Separators dialog of the CsvDataSource Wizard of the Report Designer

    If the same symbol, for example semicolon, is selected for both field and record separators this is not considered to be a valid CSV format. A warning will be displayed and moving forward will not be possible.

  3. Escape Format Choose the Escape format that is most suitable for the CSV document. If Quotes or QuotesMixed is checked the Quote option also must be configured. If the CSV document has comments enter the symbol which marks the start of a comment. If nothing is set the document is considered to not have comments. For more information regarding the Escape formats please check CsvDataSource Escape Formats.

    Escape Format dialog of the CsvDataSource Wizard of the Report Designer

  4. CSV Headers If the CSV document has a header row check the checkbox.

    CSV Headers dialog of the CsvDataSource Wizard of the Report Designer

  5. Map Columns to Types Choose the data type for each column. Set the number (decimal and thousand separators) and date formats for the CsvDataSource. In case the CSV document does not have headers, the column names could be edited directly in the grid, so your data set fields would have meaningful names.

    Map Columns to Types dialog of the CsvDataSource Wizard of the Report Designer

  6. Preview Data Source Results Preview the result set returned by the data source.

    Preview Data Source Results dialog of the CsvDataSource Wizard of the Report Designer

In this article