[General] Two Solutions Selp You Save Complex Reports on the Mobile Terminal

There are many complex reports, generally of two types:

1)All columns are data of the same dimension, such as time dimension, 12 months in a year;

2)Different columns are data of different dimensions, which is an analysis of the three dimensions of "region", "supplier", and "employee".

On the mobile side, these reports are not very adaptive. At this time, we can choose two alternatives to improve these disaster effects.

For the first type, you can use the horizontal screen to view, or reduce the number of rows, or you can set the header to freeze display, vertical screen and vertical adaptive, and view by sliding left and right. Refer to the help document for the implementation method: mobile adaptive;

For the second type, you can use the design idea of the App interface to separate the analysis dimension from the main body of the table, and view the data of different dimensions by clicking on the names of different dimensions.

Open the template: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\demo\Report\Pagination Report\Partition and Freeze.cpt

Create a new dashboard, drag in a report block, copy the content in Freeze.cpt to the report block, set the repeated header row and freeze attributes, and drag in a report block for parameter control. The specific template design style is as follows :

The upper report block is used for parameter control, and the lower report block is used for data presentation; the parameter linkage between the report blocks controls the hiding of the main report column. So as to achieve: Click on the name of the dimension to switch to view the effect of the content.

1. Hyperlink performs parameter control

When you click regions/suppliers/employees/all, the value of the parameter type is passed to the upper and lower report blocks respectively, and the value of type is 1/2/3/4, so as to control the cells in the upper report block to display different styles and control hiding of the main report block column below.

Edit the report block above, select cell A1, add a hyperlink, add a link to select dynamic parameters, and pass the value of the parameter type to 1, as shown in the figure below:

In the same way, add a hyperlink to the suppliers/employees/all and pass the parameter type as 2/3/4 respectively.

2. Parameters control cell style

For the sake of beauty, remove the hyperlink style, modify the font color, and remove the underline, as shown in the following figure:

Set the conditional attributes for the cells of the above report block. Set the formula $type=1 in the Regions of cell A1. When the type=1, the background and font will change, as shown in the figure below:

Cells B1~D1 are also set with condition attributes, and the formula conditions are set as $type=2, $type=3, and $type=4 respectively.

3. Hiding the parameter control column

Set the condition attribute to C4. When the type is not 1, that is, $type=2 or $type=3, the column where the regions is located will be hidden, as shown in the following figure:

Also set the condition attribute to E4, when the type is not 2, that is, when $type=1 or $type=3, the column where the suppliers is located will be hidden.

Also set the condition attribute to G4, when the type is not 3, that is, $type=1 or $type=2, the column where the empolyees is located will be hidden.

4. Repeat and freeze

In the report block below, set repeated header rows for 4-5 rows, and set the freeze attributes, click the freeze button on the toolbar, and the repeat and freeze settings will pop up. Select the repeated header row from column A to column B, as shown in the figure below :

5. Adaptive settings

The mobile terminal is set to non adaptive, as shown in the figure below:

In this way, in the report block of the dashboard, the data of a single dimension can be displayed by sliding up and down, and the display effect is greatly improved. In the example, in addition to the data of different dimensions, a way to display all is provided. The full amount of data can be displayed by sliding up and down, left and right. To show. The actual effect is as follows:

Create a Tab component for the data dimension, create a report block in the Tab block, copy the original report content directly to the newly created report block, and delete data columns that are not current dimensions. The report style design is shown in the figure below:

To set the freeze attribute for the report block, you can refer to the method in Method 1 for setting.

The actual display effect is as follows:

Similarly, in the report block of the dashboard, a single dimension of data can be displayed by sliding up and down, and the full amount of data can be displayed by sliding up and down, left and right.

In terms of workload, the two methods are not much different. The dashboard linkage method uses parameter linkage and report hiding. The Tab component method adds multiple new report blocks. Because we support the daashboard component and the content of the report block multiplexing, so the operation is relatively simple.

Method one: linkage of dashboard

Advantages: You can set the effect of dimension switching according to your own preferences, and use native analysis without losing the app's own functions.

Defects: There is only one display frame. The display content of different widths cannot be solved by a single vertical screen and horizontal adaptation. The report width needs to be adjusted slightly. When there are more dimensions, the switching effect is defective. Refresh the report block above. It is displayed on the left, and the effect of the switch is not displayed.

Method 2: Tab component

Advantages: There are different report blocks for different dimensions, and the vertical screen adaptive method can be set according to the number of columns, which is more reasonable.