VB.net, SQLite & designer mode

alex@moons.nl

Where can I find a how-to, to design my reports with SQLite database driven data?

After searching Google and Forum, I found different topics with possibilities, but with none of them I can figure out how to implement (the plugin?) in Visual Studio 2015 Express. I found the connection FastReport.SQLite and already compiled the FastReport.SQLite.dll, but now I'm stuck how to implement the SQLite datasources in report wizard in designer mode.

alex@moons.nl

Never mind, I found the solution in a readme.txt in the folder: FRNetConnections\Extras\Connections\FastReport.SQLite\readme.txt

wrote:

SQLite data connection for FastReport.Net

---

How to compile:

---

- you need the SQLite .Net Data Provider to be installed. Obtain it
at [url="http://sqlite.phxsoftware.com;"; ] http://sqlite.phxsoftware.com;[/url]
- open the .sln file;
- fix the "FastReport.dll" reference. By default, this dll is located in the
"C:\Program Files\FastReports\FastReport.Net Demo" folder;
- check that "System.Data.SQLite.dll" reference is correct.
If Visual Studio complains about it, fix this reference as well;
- compile the project. You will get the "FastReport.SQLite.dll" file.


How to register this dll in FastReport:

---

You can do it in several ways:

1) register using the FastReport IDE
- open the report designer;
- go "View|Options..." menu;
- on the "Plugins" tab, add the FastReport.SQLite.dll;
- restart FastReport. If you are working in the Visual Studio IDE, restart
it as well;

2) edit manually the FastReport.config file
- by default, this file is located in the "C:\Documents and Settings\user_name\
Local Settings\Application Data\FastReport" folder;
- close any running instances of FastReport.Net;
- open the config file in any text editor and modify it in the following way:
<?xml version="1.0" encoding="utf-8"?>
<Config>
...
<Plugins>
<Plugin Name="c:\.....\FastReport.SQLite.dll"/>
</Plugins>
</Config>

3) register the dll programmatically
- add the "FastReport.SQLite.dll" reference to your project;
- execute the following code once at the application start:
FastReport.Utils.RegisteredObjects.AddConnection(typeof(SQLiteDataConnection));


How to use it:

---

- now you should be able to create a new SQLite data source in the
"Data|Add Data Source..." menu.