How to connect to VistaDB

2019-11-15

The Vista database will fall into the type of embedded databases. These databases differ from client server databases in that they are designed to be embedded in a client application as a file. The range of tasks of such a base will also be different from the database. Typically, these are databases that are only used in one application and are not intended for sharing. In this way, VistaDB stands in line with the SQLite and the SQL Ce.
Let's look at the way to connect to such a database inside a report. To do this, we will need to connect the report designer to a plug-in connector located in the folder:

C:\Program Files (x86)\FastReports\FastReport.Net\Extras\Connections\FastReport.VistaDB

The result of assembling of the project will be FastReport.VistaDB.dll library.

Let’s open report designer, menu File->Options:

 

On the Plugins tab, add a reference to the previously created FastReport.VistaDB.dll library. After that restart the report designer.
Now let’s add a new data source to the report. When creating a connection, select now available VistaDB connection:

 

Setting up a connection is about selecting a database file and entering a password to it if you're asked.
Next, let's move on to selecting tables:

 

Here we can select a table and complete the creation of a data source. However, it is possible to filter the data with the SQL query. To do this, click the "Add SQL query...".
Let's give the data view the name that appears in the table list after the request is created:

 

Write SQL query itself:

 

Here we used a parameterized query. Parameter itself we will announce in the next query wizard step:

 

Parameter name corresponds to a parameter in the query. The parameter may be any expression: function, text report variable, a system variable. Do not forget to also determine the type of the parameter data. It must match the data field with which we compare the parameter in the query. As a result, we obtain a new "custom" table:

 

 We used the report parameter as a value of query parameter:

 

As a result we will get the following data;

Using the plug-in to connect VistaDB makes it easier and faster to create a data source, and using a parameterized request to filter the data allows you to transfer the value of the outside of the report to the filter (using the code app or through the URL).

.NET .NET FastReport FastReport Connection Connection Data Source Data Source
April 22, 2025

Working with the TfrShellTreeView Component in FastReport VCL

In this article, we will look at the TfrShellTreeView component. It is designed to display file system elements and is partially analogous to the TDirectoryListBox, TDirectoryOutline, and TShellTreeView components.
April 21, 2025

How RFID Tags Work in FastReport VCL

In this article, we'll check out how RFID tags work with the new TfrxDeviceCommand object in FastReport VCL with release 2025.2.
April 08, 2025

Converter from Microsoft Word (.docx) format to FastReport .NET (.frx) file

A converter from Microsoft Word (.docx) format to a file FastReport .NET (.frx): description and instructions for using the tool.
Fast Reports
  • 800-985-8986 (English, US)
  • +31 97 01025-8466 (English, EU)
  • +49 30 56837-3928 (German, DE)
  • +55 19 98147-8148 (Portuguese, BR)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2025 Fast Reports Inc.