logo
small logo
  • Produits
  • Acheter
  • Assistance
  • About
  • Panneau du client Assistance
    • en
    • de
    • JP
    • ZH
  • Page d'accueil
  • /
  • Articles
  • /
  • How to connect to Firebird from FastReport.Net
  • Toilet paper printing

    30 mars 2020

    Gentlemen jokes aside! Today we are talking about toilet paper. This essential hygiene product was

    read more
  • FastReport .NET packages and .NET 5.0

    17 décembre 2020

    UPD: Applies to the versions of FastReport .NET before 2022.2. License packages are now available

    read more
  • How to use Online Designer in ASP .NET Core

    17 janvier 2018

    One of the novelties by FastReport .NET 2018 was the adaptation of OnlineDesigner to the

    read more
  • PreviewControl.OnPrint and PreviewControl.OnExport Events

    1 octobre 2020

    In FastReport 2019.4 added the ability to subscribe to PreviewControl.OnPrint and PreviewControl.OnExport events, which are

    read more
  • How to connect to MongoDB from the FastReport.Net report

    16 novembre 2019

    First of all, you need to assemble a plug-in connector library to the database for

    read more

How to connect to Firebird from FastReport.Net

15 novembre 2019

In order to connect to Firebird database in FastReport.Net Designer a plug-in connector is provided.

It is necessary to pre-assemble the project:
С:\Program Files (x86)\FastReports\FastReport.Net\Extras\Connections\FastReport.Firebird

Then you have to connect the plug-in report designer in the menu File-> Options:

 

After that, you need to restart the report designer.
Before you create the source data in a report make sure that your server FireBird is properly configured. The fact that the Firebird 3 when connecting to a database using FireBirdSql.Data.FirebirdClient library, which is used in the plugin, you will likely see the error "connection rejected by remote interface". You need to enable wire encryption and Legacy authentication type.
To do this, open the configuration file firebird.conf. Uncomment and change the line:

AuthServer = Srp, Legacy_Auth

UserManager = Srp, Legacy_Auth

WireCrypt = Enabled

Now we can start making the data source. Select the connection type “Firebird connection”:

 

As a result, the connection line will look like this:

initial catalog="J:\Program Files\Firebird\Firebird_3_0\examples\empbuild\EMPLOYEE.FDB";user id=sysdba;password=masterkey

Next, we can choose the tables needed for the report:

 

But also, we have the opportunity to write the SQL query. Let's look at this opportunity. Push the button "Add SQL query ...". We set the table name, which is obtained as a result of the query:

Then let’s write SQL request itself:

 

This request is in the condition parameter. With the help of a double vertical line, we perform a concatation. As a result of this inquiry, we will be presented employees whose names begin with a certain letter or phrase. In the next step we create a parameter with the same name, which we have defined in a SQL query:

 

As a setting value, we can use any expression: report setting, function, variable. Let's use the report variable. By this point it should have been created:

 

Choose it in the expression editor which will open when you click Expression in the window of making the parameter request:

 

As a result, we will get the selection of these employees whose name starts with K:

A propos de notre produit Acheter
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport Firebird

Ajouter un commentaire
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
  • Acheter
  • Télécharger
  • Documentation
  • Avis
  • Comment désinstaller nos produits
  • FAQ
  • Tutoriel vidéo
  • Forum
  • Articles
  • Nos actualités
  • Dossier Presse
  • Partenaires
  • Extended licensing
  • Nous contacter

© 1998-2023 by Fast Reports Inc.

  • Politique de confidentialité
  • Pas une offre publique