logo
small logo
  • Produkte
  • Shop
  • Support
  • Articles
  • Customer panel Support
    • en
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to connect to VistaDB
  • How to connect to OracleDB from FastReport .NET

    15. November 2019

    First of all, you can use the ODBC connector. But it is fraught with a

    read more
  • Toilettenpapier drucken

    30. März 2020

    Meine Herren, Scherz beiseite! Heute sprechen wir über Toilettenpapier. Dieses unverzichtbare Hygieneprodukt wurde erst im

    read more
  • MS Word versus Open Document Text. Was ist besser?

    19. Oktober 2020

    Wenn wir von Texteditoren sprechen, stellen wir uns die Leuchte sofort als Microsoft Word vor,

    read more
  • Starten der Anwendung aus FastReport .NET heraus in Docker für Linux

    17. November 2021

    Docker ist eine Software-Plattform für eine schnelle Entwicklung, Prüfung und Bereitstellung von Anwendungen. Es ermöglicht

    read more
  • Wollten Sie Tabellen für den Benutzer generieren - Excel oder OpenOffice Calc?

    8. Oktober 2020

    Tabellen. Seit Jahrhunderten werden sie verwendet, um dieselbe Art von Daten für Buchhaltungszwecke, Zählbeträge und

    read more

How to connect to VistaDB

15. November 2019

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).

about product download buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport Data Source VistaDB

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Shop
  • Download
  • Dokumentation
  • Referenzen
  • Informationen zur Deinstallation unserer Produkte
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Unsere Nachrichten
  • Presse über uns
  • Partner
  • Außergewöhnliche Lizenzierung
  • Kontakte

© 1998-2022 by Fast Reports Inc.

  • Datenschutz