Using MS Access Database in the Report
|Product Version||220.127.116.118 and above|
Since version 18.104.22.1688 we provide support for MS Access. This article lists the required steps for setting MS Access Database and using it in the report.
Create a sample database in Access:
Create a new report and insert SQL Data Source.
- Click on Build new data connection and select OleDB Data Provider from the dropdown.
- The data source has to be a Microsoft Access Database File (OLE DB).
- Browse to the file’s location.
- Click OK and finish the Wizard with the default settings.
In the Configure data source command dialog, click on Query Builder and mark the desired fields: