I. Description
To use the FineReport designer to design a template, you first need to understand the idea of making the FineReport template, and follow the idea to understand all the functions in the FineReport report.
The FineReport report production process is as follows:

1) Create a new data connection: Before making a template, first make sure that the designer knows the database type, database address, user name and password for accessing the database, and then create a new data connection in the FineReport designer to establish the interaction between the database and the designer bridge;
2) Create a new template and dataset: After the data connection is created, you need to add a template. The data connection is used for the entire project. It does not actually take the data out of the database, so it needs to be in a specific template. Create a new dataset and fetch data from the database through a data connection;
3) Template design: After the data preparation is completed, the template design is carried out. The template design is the most important part of the FineReport learning process. We divide the template design into four parts: report design, parameter design, chart design and report design. , These four parts are the main ways to use the FineReport template. The report design is pure data display, the parameter design is dynamic query data, the chart design uses charts to display data, and the report design is to enter data and write the data into the database. , According to the actual situation, determine which way to use, or which ways to use in combination;
4) Template preview: After the template design is completed, save the template under the project directory to preview and view the effect of the template on the Web.
II. Index
| Serial Number | Content | Introduction | Help Document | |
|---|---|---|---|---|
| 1 | Data Connection | Establish an interactive bridge between the database and the designer | Data Connection Overview | |
| 1.1 | JDBC Connect Database | Take the connection to Oracle database as an example to introduce the operation steps of connecting to the database in JDBC mode | [Designer] JDBC data connection | |
| 1.2 | JNDI Connect Database | Define data connection through JNDI | [Designer] JNDI data connection | |
| 1.3 | XMLA Data Connection | Connect with multidimensional database through XMLA data connection | Cube plugin | |
| 1.4 | SAP Data Connection | FineReport makes the SAP data connection function a plug-in, adds SAP data connection type, and adds SAP data set type | SAP Dataset Plugin | |
| 2 | Dataset | Dataset refers to the data display set that is taken out from the database and can be directly applied to the template design | Dataset | |
| 2.1 | Database Query | For the database tables in the data source, directly use SQL statements to select the required data fields | Database Query | |
| 2.2 | Built-in Dataset | Create a new original table similar to a database table, which can be used as a template data source to design reports | Built-in Dataset | |
| 2.3 | File Dataset | Refers to using the data in TXT text files, Excel files and XML files as data sets, and displaying them in the data set in a two-dimensional table structure | File Dataset | |
| 2.3.1 | TXT Dataset:It means that the data source is a series of TXT text files | TXT and XML Dataset | ||
| 2.3.2 | Excel Dataset:It means that the data source is a series of XLS files | Excel Dataset | ||
| 2.3.3 | Remote Excel Dataset:Access the JSP page through URL, and use the corresponding Excel file as a dataset | Remote Excel Dataset | ||
| 2.3.4 | XML Dataset:Means that the data source is a series of XML files | TXT and XML Dataset | ||
| 2.4 | SAP Dataset | First establish an SAP data connection, and establish an SAP data set through the data connection | SAP Dataset | |
| 2.4.1 | Custom access:Is to directly call ABAP Function to get data | Custom Access | ||
| 2.4.2 | Simple general query access:Through the open SQL statement, read certain columns from a table and list some conditions that the data needs to meet | Simple general query access | ||
| 2.4.3 | General query access:Compared with simple general queries, general queries increase the ability to associate between tables and support multi-table queries | General query access | ||
| 2.4.4 | Functions in general query access:Detailed description of the creation process of EXTRACT_TABLE_DATA and problem solving | Functions in general query access | ||
| 2.5 | Stored Procedure | The stored procedure is to directly use the stored procedure as a data set, without querying in the database but to call the stored procedure | Stored Procedure | |
| 2.6 | Multidimensional database | On the basis of XMLA data connection, create a new multidimensional database XMLA dataset | Multidimensional database | |
| 2.6.1 | Simple general query:Refers to FineReport directly displaying the multi-dimensional CUBE structure after connecting to the multi-dimensional database through XMLA | Simple general query | ||
| 2.6.2 | Custom MDX query:Means that the user directly enters the MDX query statement in the MDX statement input box, and FineReport uses the statement to fetch data from the multidimensional database | Custom MDX query | ||
| 2.7 | Associated Dataset | Filter and fetch data from different data sources; access different databases; use different data sources to form a dataset | Associated Dataset | |
| 2.8 | Tree Dataset | Bind the tree dataset for the widget, and the tree hierarchical structure will be automatically generated when viewed on the Web side | Tree Dataset | |
| 3 | Template Design Types | FineReport template design mainly includes three template design types: normal template design, dashboard design and aggregate report design | Template Design Types | |
| 3.1 | Normal Report Design | Normal report design is divided into four parts: report design, parameter design, chart design and data entry design | Normal Report Design | |
| 3.2 | Dashboard Design Mode | Realize the self-adaptation of the mobile terminal and the linkage between the components through the dashboard | Dashboard Design Mode | |
| 3.3 | Aggregate Report Design | Aggregated report refers to a report that contains multiple modules, each of which is similar to a separate report or a chart, and the blocks are relatively independent and do not affect each other | Aggregate Report Design | |
| 4 | Template Preview | FineReport has a variety of preview modes: Pagination Preview, Data Entry Preview, New Data Entry Preview, Data Analysis, Mobile Preview~ | Template Preview | |
| 4.1 | Pagination Preview | The default preview mode of FineReport is generally used when you only need to view report data for analysis | Pagination Preview | |
| 4.2 | Data Entry Preview | Refers to the template used to fill in the data in the web preview, generally used when you only need to enter and modify the data | Data Entry Preview(op=write) | |
| 4.3 | Data Analysis | Data analysis mode can also view reports, but it can preview the report results without pagination and online analysis: sorting, secondary filtering, etc. | Data Analysis(op=view) | |
| 4.4 | New Data Entry Preview | New Data Entry Preview, new style widgets, fast loading speed, and pagination loading | New Data Entry Preview(op=write_plus) | |
| 4.5 | Mobile Preview | Display the report directly on the mobile phone by scanning the code, allowing users to intuitively see the actual effect of the current design template | Mobile Preview(op=mobile) | |
| 4.6 | Dashboard Preview | Dashboard Preview is for the design mode of dashboard | Dashboard Preview | |