Using MS Access Database in the Report

Environment

Product Version	13.1.19.618 and above
Product	Telerik Reporting

Description

This article lists the required steps for setting MS Access Database and using it in the report.

Solution

1. Create a sample database in Access:

   

2. Create a new report and insert SQL Data Source.

3. Click on Build new data connection and select OleDB Data Provider from the dropdown.
4. The data source has to be a Microsoft Access Database File (OLE DB).
5. Browse to the file’s location.
6. Click OK and finish the Wizard with the default settings.

7. In the Configure data source command dialog, click on Query Builder and mark the desired fields: