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

    15. November 2019

    The Vista database will fall into the type of embedded databases. These databases differ from

    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
  • Verbindung zu Elasticsearch

    10. November 2021

    FastReport .NET-, Core-, Mono-, OpenSource-Produkte können jetzt eine Verbindung zu Elasticsearch herstellen. Elasticsearch ist ein

    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 OracleDB from FastReport .NET

15. November 2019

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

 

As you can see, you need to create the data source and the connection string to it. Relatively a lot of action.
An alternative to this method is to use connector from FastReport.
In fact there are two connectors to choose from. In FastReport.Net package, the source code is included with various demonstration projects and additions. By additions we understand plug-ins for the report designer, which you can add or remove as needed.
We are interested in the plugins folder located in:

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

There are two projects FastReport.Oracle and FastReport.OracleODP. The first one uses OracleClient library, and the second - Oracle.DataAccess.
In practice, the only difference is in one detail. Here is the form for the creation of the connection for the first plug-in:

 

And here is the form for the second plugin:

 

The difference is that in the second case we have a list of available servers, you do not need to enter the name manually.
Once you've connected to the database, you'll need to select the tables from which you want to draw the data.

 

But if you want to filter the data on this stage, you need to use SQL Query builder:

 

The main advantage of the SQL query is the ability to parameterize it. For example, using such a request we will select all the fields from the Product table for the records with the value of the field PRODUCT_CD beginning with a specific letter or word:

 

In the PL/SQL notation, the parameters are defined by the ":" symbol. In the next step, we create a set that we've already specified in the query. We set for him the same name:

 

Any expression available in the expression manager can act as a parameter value. But the most logical way is to use the report parameter. After all, it is possible to transfer the value from the outside, before building a report. The image above shows the name of the report parameter. By the time this query is created, it is desirable that the report setting has already been created. Then you can choose it in the expression manager. But it is not fundamental. You can always enter the option name manually and then create it:

 

Let's go back to the previous figure. DefaultValue field is used, if the value of Expression is empty.
So we looked at the way you can connect to the Oracle database and how to use parameters in a SQL query.

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

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
  • Kontakte

© 1998-2022 by Fast Reports Inc.

  • Datenschutz