How to connect to Firebird from FastReport .NET

2019-11-15

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:

August 12, 2024

How to build and install the Postgres plugin in FastReport .NET

This article describes how to connect to the database using the FastReport .NET plugin for the report designer from Visual Studio via the NuGet server.
August 08, 2024

How to install FastReport .NET and its components on Windows

Step-by-step instructions for online and manual installation via the FastReport registration code.NET and its components in Windows.
July 26, 2024

Updating HTMLObject as a plugin for FastReport .NET

Detailed instructions for using the new HTMLObject plugin, which uses splitting DOM HTML into FastReport report objects.
Fast Reports
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314

© 1998-2024 Fast Reports Inc.