I. Overview
1. Version
| FineReport version | Function changes |
|---|---|
| 10.0 | - |
| 10.0.19 | Data set preview interface supports copying |
2. Function introduction
Dataset means that taking data out of the database, which means data display collection that can be directly applied to template design.
According to the scope of use, the dataset can be divided into "server dataset" and "template dataset".
According to its source range, datasets can be divided into Database query, Built-in dataset, File dataset, SAP dataset, Stored procedure, Multidimensional database, Relation dataset and Tree dataset.
Note: The name of the dataset cannot contain the English punctuation "."
II. Data set classification
1. Server dataset
The server data set corresponds to the entire report project. If you change a template or create a new workbook, you can still use the data in the server dataset.
Click Menu>Server>Server Dataset, the Server Dataset interface will pop up, and all the defined server dataset information is stored in the fine_conf_entity table of FineDB.
Click +, the server dataset can extract data from DB Query, Class, Embedded, File, Stored Procedure, Realtion, Tree, as shown in the figure below:
2. Template dataset
The template dataset corresponds to the current template and is saved in the cpt file of this template. It cannot be shared with other templates and is private.
Click Template> Template Dataset, the following interface will appear:
Drag and drop the table to the statement input area to quickly create SQL query statements, as shown in the following figure:
3. Dataset type
According to the data source, the dataset types are divided into: Database query, Built-in dataset, File dataset, SAP data set, Stored procedure, Multidimensional database, Relation dataset and Tree dataset.
| Dataset type | Definition |
|---|---|
| Database query | For database tables in the data source, directly use SQL statements to select the required data fields. |
| Built-in dataset | Create a new table similar to a database table, which can be used as a template data source to design reports. |
| File dataset | It refers to the dataset in TXT text files, Excel files and XML files, and displayed in the dataset in the structure of a two-dimensional table. |
| SAP dataset | Firstly establish a SAP data connection, through the data connection to establish the SAP data set. |
| Stored procedure | Stored procedure is to directly use the stored procedure as a dataset, without querying in the database but to call the stored procedure |
| Multidimensional database | On the basis of XMLA data connection, create a new multidimensional database XMLA dataset. |
| Relation dataset | Filter and fetch data from different data sources; access different databases; use different data sources to form a dataset. |
| Tree dataset | Bind the tree dataset to the widget, and the tree hierarchical structure will be automatically generated when viewed on the Web side. |
III. Data set window
In the dataset pane on the left side of the designer, all the added datasets will be displayed, including the template dataset and the server dataset, as shown in the following figure:
Note: The dataset window can add, delete, edit, and preview the template dataset, but can only preview the server dataset and stored procedure dataset.
1)The user can preview the dataset in the dataset window and when adding the dataset, as shown in the figure below:
2)In the preview interface, the user can directly use the mouse to frame selection, or use the shift key to select multiple cells. Then use control+c (ios:command+c) to copy the data in the preview interface. As shown below:
3)Select the header and drag it to move the column position; click the header cell to sort the column. As shown below:
IV. Index
| No. | Contents | Introduction | Document Tutorial |
|---|---|---|---|
| 1 | Database query | For database tables in the data source, directly use SQL statements to select the required data fields. | Database query |
| 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 |
| 3 | File dataset | It refers to the dataset in the TXT text file, Excel file and XML file, and displayed in the dataset in the structure of a two-dimensional table. | |
| 1) | Text dataset:It means that the data source is a series of TXT text files. | TXT dataset | |
| 2) | Excel dataset: It refers to the data source is a series of XLS files Excel data set | Excel dataset | |
| 3) | Remote Excel dataset:It access the JSP page through URL, and use the corresponding Excel file as the dataset. | ||
| 4) | XML dataset:It refers to the data source is a series of XML files. | XML dataset | |
| 4 | SAP dataset | Firstly establish a SAP data connection, and establish the SAP dataset through the data connection. | |
| 1) | Custom access: It call ABAP Function directly to get data. | ||
| 2) | Simple general query access:It read certain columns from a table through the open SQL statement, and list some conditions that the data needs to meet. | ||
| 3) | General query access: Compared with simple general query, general query increases the ability to associate between tables and supports multi-table query. | ||
| 4) | Functions in general query access: A detailed description of the creation process of EXTRACT_TABLE_DATA and problem solving | ||
| 5 | Stored procedure | Stored procedure is to directly use the stored procedure as a dataset, without querying in the database but to call the stored procedure. | Stored procedure |
| 6 | Multidimensional database | On the basis of XMLA data connection, create a new multidimensional database XMLA dataset. | |
| 1) | Simple general query:It refers to the direct display of the multidimensional CUBE structure after FineReport connects to the multidimensional database through XMLA. | ||
| 2) | Custom MDX query:It refers to the user directly enters the MDX query statement in the MDX statement input box, and FineReport uses the statement to access the multidimensional database to obtain the data. | ||
| 7 | Relation Dataset | Filter and fetch data from different data sources; access different databases; use different data sources to form a dataset. | Relation dataset |
| 8 | Tree Dataset | Bind the tree dataset to the widget, and the tree hierarchical structure will be automatically generated when viewed on the Web side. | Tree dataset |
