ActiveReports 13
Bind a Section Report to CSV Data Source
ActiveReports 13 > ActiveReports User Guide > Samples and Walkthroughs > Walkthroughs > Section Report Walkthroughs > Data > Bind a Section Report to CSV Data Source

This walkthrough illustrates binding a section report to a CSV data source.

The walkthrough is split up into the following activities:

Note: This walkthrough uses the Products_header_tab.csv sample database. By default, the Products_header_tab.csv file is located at [User Documents folder]\GrapeCity Samples\ActiveReports 13\Data.

When you complete this walkthrough you get a layout that looks similar to the following at design time and at run time.

Design-Time Layout

Run-Time Layout

To add an ActiveReport to the Visual Studio project

  1. Create a new Visual Studio project.
  2. From the Project menu, select Add New Item.
  3. In the Add New Item dialog that appears, select ActiveReports 13 Section Report (code-based) and in the Name field, rename the file as rptProductsStock.
  4. Click the Add button to open a new section report in the designer.

See Adding an ActiveReport to a Project for information on adding different report layouts.

To connect the report to a data source

  1. On the detail section band, click the Data Source icon.
  2. In the Report Data Source dialog, on the CSV tab, click the Build button next to Connection String.
  3. To specify the File Path, click the Open button and navigate to [User Documents folder]\GrapeCity Samples\ActiveReports 13\Data and select the Products_header_tab.csv file.
  4. Select the Column Separator as Tab from the drop-down menu. See the Sample CSV Connection String drop-down in CSV Data Provider topic for further details.
  5. Click OK to save the changes and close the Configure CSV Data Source wizard. The Connection String tab displays the generated connection string as shown below:
    Path=C:\\[User Documents folder]\\GrapeCity Samples\\ActiveReports 13
    \\Data\\Products_header_tab.csv;Locale=en-US;
    TextQualifier=";ColumnsSeparator= ;RowsSeparator=\r\n;HasHeaders=True

  6. Click OK to close the Report Data Source dialog. You have successfully connected the report to the CSV data source.

To view the report

OR

See Also