In this article I would like to see a connection to a SQLite database from a report. We will look at this in two examples. The first - with the help of plug-in for Report Designer, the second - with the help of ODBC SQLite driver.
So, to use a plugin from FastReports, you must first make it. To do this, open solution FastReport.Net\Extras\Connections\FastReport.SQLite. The references need to fix two links - at the library FastReport.dll and System.Data.SQLite.dll. The last one will have to download from the Internet. Build the solution. We get FastReport.SQLite.dll library in the bin \ Debug folder.
Now open the report designer. On the File menu, select Options. Open the Plugins tab in the form that appears.
Use the Add button to add libraries created above. Restart the report designer.
On the toolbar, select the Report tab and add ...