Overview
Version
| Report Server Version |
|---|
11.0 |
Application Scenario
The data analysis preview mode allows for simple analysis operations, including sort, condition filter, and list filter when you view data.
Function Description
The following two data analysis preview modes are available.
Button: You can directly select Data Analysis Preview from the drop-down button list Preview.
Suffix: You can directly add the suffix &op=view to the viewing URL.
Note:1. Mobile terminals do not support data analysis preview.
2. During data analysis preview, the data will not be displayed by page.
Data Analysis Preview Setting
Setting Method
Using Server Settings
Use Server Settings is selected by default, in which all the functions below are grayed out and non-editable. This setting method is suitable for all templates on the current server.
You can choose Server > Server Configuration > Data Analysis Setting to modify the predefined data entry preview setting of the server.
Setting for This Template Separately
You can choose Template > Web Attribute > Data Analysis Setting, and select Set for This Template Separately from the drop-down list of Following Settings. Then all the functions below become editable. The configured page settings will only apply to the current template and do not take effect for other templates. The following figure shows the effect.
The following table describes the main function modules.
| Function | Content | Notes |
|---|---|---|
Sort | After selecting a cell, you can use the sorting tool to sort the data in the column where the cell is located. | / |
Condition Filter | After selecting a cell, you can set the three conditions, namely the operator, data type, and value to obtain certain data by filtering from the column where the cell is located. | / |
List Filter | After selecting a cell, you can select required data from the deduplicated data list in the column where the cell is located to display only the selected data. | If more than 100 deduplicated data records are displayed on the frontend, the List Filter tool will not be displayed. |
Toolbar | You can determine whether to display the toolbar and customize the content displayed on the toolbar. | This function is not supported on mobile terminals. |
Event Setting | This function is not supported on mobile terminals. |
Sort
Sort allows you to select a cell and then use the sorting tool to sort the data in the column where the cell is located. This function is ticked by default and the following figure shows the effect.
Condition Filter
Condition Filter allows you to select a cell and set three conditions (namely, the operator, data type, and value) to obtain certain data by filtering from the column where the cell is located. This function is ticked by default and the following figure shows the effect.
List Filter
List Filter allows you to select a cell and then select required data from the deduplicated data list in the column where the cell is located to display only the selected data. This function is ticked by default and the following figure shows the effect.
Toolbar
The Use Toolbar function is selected by default. That is, the toolbar is displayed above the report during the data entry preview. Deselect the function if you do not need it. The usage method of this function is the same as that in Pagination Preview.
The default buttons on the data analysis preview toolbar are Page Setting, Print Preview, Print, Export, and Email, as shown in the following figure.
Page Setting: You can set Orientation, Paper Size, and Margin for a report during printing. The following figure shows the effect.
Print Preview: You can preview the print effect.
The effects of the other buttons are the same as those in the pagination preview.
Display Setting
You can click the + icon in Event Setting and add JS events to meet other preview needs through JavaScript codes.
Notes
Unavailable Sort
You need to set Data Setting to List for the foremost parent cell and Group for other columns in the data analysis preview mode. Otherwise, only data in the foremost parent cell can be sorted and data in other cells cannot be sorted.
No List Filter Tool Displayed
If more than 100 data records are displayed on the frontend, the List Filter tool will not be shown. This is determined by the FineReport data volume limitation rule.
Unavailable Analysis Tool
These three data analysis tools are unavailable in the following scenarios.
1. Data obtained through bidirectional expansion cannot be processed by the data analysis tools.
2. Data in a cell with multi-leveled parent cells from the same dataset cannot be processed by the data analysis functions.
| Example | Scenario | Result | Analysis |
|---|---|---|---|
1 | Cell B1 is the parent cell of cell C1. Cell A1 is the parent cell of cell B1. Cell A1 has no parent cell. Data in cells A1, B1, and C1 originates from the same dataset. | Data analysis functions are available for cells A1 and B1, but unavailable for cell C1.
| The parent cell level of cell C1 is 2. Data in parent cells A1 and B1, and cell C1 originates from the same dataset. |
2 | Cell C1 is the parent cell of cell B1. Cell A1 is the parent cell of cell B1. Cell A1 has no parent cell. Data in cells A1 and B1 originates from the same dataset, while data in cell C1 originates from another dataset. Cell C1 are associated with cells A1 and B1 through filtering. | Data analysis functions are available for cells A1, B1, and C1. | / |
3 | Cell D1 is the parent cell of cell E1. Cell E1 is the parent cell of cell D1. Cell C1 is the parent cell of cell B1. Cell A1 is the parent cell of cell B1. Cell A1 has no parent cell. Data in cells A1 and B1 originates from the same dataset, while data in cells C1, D1, and E1 originates from another dataset. Cell E1 is associated with A1 and B1 through filtering. | Data analysis functions are available for cells A1, B1, C1, and D1, but unavailable for cell E1.
| The parent cell level of cell E1 is 2. Data in cells C1, D1, and E1 originates from the same dataset. |
Removing the Black Frame of the Selected Cell
During data analysis preview, a selected cell will be framed by a black border, which may affect the overall report appearance. So, how to remove this border?
For details about the solution, see Removing the Black Frame of a Selected Cell by JS on the Data Analysis Page.
Upper Merging Limit
Up to 2047 rows and columns can be merged by the report engine, and up to 1000 rows and columns can be merged during frontend rendering. If the number of merged rows and columns exceeds the limits, data may not be displayed completely in the data analysis preview mode.
Previous：Data Entry Preview
