Finereport database Connection (Oracle+plsql) (1)

I. Database-building Tables

The database is oracle12c, and the tool is plsql. Specific operation Baidu can, here do not repeat. (Fig. 1)

Figure 1

Two. Establishing a database connection in Finereport

In the Upper tab, click Server, and select define data connection. Note If the driver supports ORACLE12C, update the driver if it is not supported. Specific operations are described in the official Finereport manual. Figure (2).

、

Figure 2

Three. Adding a template data set

Click the green plus sign, select the newly created data table in Oracle, my table named N2sheet_demo, drag directly into the blank area, the SQL statement will appear, according to their own needs to write. Figure (3).

Figure (3)

Simple to write, basically covers the complete set of database table +FR report steps. Specific operations (query conditions, report grouping, etc.) and then write.

Finereport database Connection (Oracle+plsql) (1)