I. Overview
1. Version
| Report server version |
|---|
| 10.0 |
2. Application scenarios
The data analysis preview mode can perform simple analysis operations on the data when viewing the data, including: sorting, conditional filtering, and list filtering.
3. Function introduction
There are two ways to preview the data analysis, as follows:
Button: Select Data Analysis Preview directly under the designer preview button list .
Suffix: Add the parameter suffix directly after the URL of the access template&op=viewThat's it.
Note 1: The mobile terminal does not support data analysis preview.
Note 2: During the data analysis preview, the data will not be displayed in pagination.
II. Data Analysis Preview Settings
1. Setting method
1) Sever Configuration MangerThe default setting method isSever Configuration Manger, and the functions at the bottom are grayed out and cannot be edited. This method applies to all templates under the current server.
If you want to modify the server's predefined data preview settings, you can click Server > Sever Configuration Manger > Data Analysis Settings" in the designer menu bar to modify it.
Click Template > Web Attributes> Data Analysis Settings in the menu bar of the designer, and select Individually set for the template from the drop-down mode, all the functions below can be edited. The configured page only applies to the current template, and other templates cannot be used. use. As shown below:
The main functional modules are as follows:
| Features | Content | Precautions |
|---|---|---|
| Sort | Select a cell and use the sort tool to sort the data in the column where the cell is located | - |
| Conditional filter | Select a cell, set the three conditions of operator, data type, and value, and filter out some data in the column where the cell is located | - |
| List filter | Select a cell, check the list of deduplicated data in the column where the cell is located, and only display the checked data | If the amount of data displayed on the front end is greater than 100, the list filter tool will not be displayed |
| Toolbar | You can set whether to display the toolbar and customize the content displayed by the toolbar | Mobile not supported |
| Event settings | User can add web events, please refer to Web page events for details | Mobile not supported |
2. Sorting
Sort means to select a cell and use the sort tool to sort the data in the column where the cell is located. It is checked by default , and the effect is as shown in the following figure:
3. Conditional filtering
Conditional filtering refers to selecting a cell, setting three conditions of operator, data type, and value, and filtering out some data in the column where the cell is located. It is checked by default , and the effect is as shown in the following figure:
4. List filter
List filter: select a cell, check the deduplicated data list of the column where the cell is located, and only display the checked data. It is checked by default , and the effect is as shown in the following figure:
5. Toolbar
By default, the system selects Use Toolbar, that is, the toolbar will be displayed at the top of the page preview. If you need to hide the toolbar, uncheck it. The usage method is the same as Section II.4 in Pagination Preview.
6. Event Settings
Click below the event settings to add JS events to achieve other preview requirements through JavaScript code. For details, see: Web Page Events
III. Precautions
1. Unable to sort
Data analysis preview sorting needs to set the foremost parent cell as a list (other columns are grouped), otherwise it cannot be sorted except for the parent cell.
2. Do not display the list filter tool
If the amount of data displayed on the front end is greater than 100, the list filter tool will not be displayed, which is determined by the FineReport data amount limit rule.
3. Unable to use analysis tools
In the following two scenarios, none of the three data analysis tools can be used.
1) The data obtained by bidirectional expansion cannot use data analysis tools.
2) When the cell existsmulti-level parent, and belongs to the parentthe same dataset, the data analysis function cannot be used.
| Example | Situations | Result | Analysis |
|---|---|---|---|
| 1 | The parent of cell C1 is B1; The parent of cell B1 is A1; Cell A1 has no parent; Cells A1, B1, C1 are in one dataset. | Cells A1 and B1 have data analysis function; Cell C1 does not. | The parent level of cell C1 is 2; and the parents A1, B1 and C1 are the same dataset. |
| 2 | The parent of cell C1 is B1; The parent of cell B1 is A1; Cell A1 has no parent; Cells A1 and B1 are in one dataset, and cell C1 is in one dataset, which is associated with cells A1 and B1 through filtering | Cells A1, B1 and C1 all have analysis functions. | - |
| 3 | The parent of cell E1 is D1; The parent of cell D1 is C1; The parent of cell C1 is B1; The parent of cell B1 is A1; Cell A1 has no parent; Cells A1 and B1 are in one dataset, and cells C1, D1 and E1 are in one dataset, which are associated with A1 and B1 through filtering. | Cells A1, B1, C1 and D1 have analysis functions; Cell E1 does not. | The parent level of cell E1 is 2; and the parents C1, D1 and E1 are the same dataset. |
4. Remove the black box when the cell is selected
When previewing data analysis, a black border will appear in the selected cell, which has a certain impact on the overall appearance of the report. So how to remove this border?
Solution: remove the black border when the cell is selected on the data analysis page
