How to realize the sorting requirement of click header of big data report

This article will explain in detail how to achieve big data report click header sorting requirements, the content of the article is of high quality, so the editor to share to you as a reference, I hope you have a certain understanding of the relevant knowledge after reading this article.

Implementation method:

Hyperlinks are implemented by combining parameters and cell expressions. Examples are as follows

The original appearance is as follows

Implementation principle: by clicking on the value of any cell in the first row, the sorting is controlled by A2 cell expression

1. First, add three parameters to the original report as follows

two。 Modify the A2 cell expression to = ds1.select (EMPID;$ {macro1}: ${macro2})

3. Set the hyperlink expression for the header cells that need to be sorted by clicking on the header, for example: I want to click on the A1 cell to switch the EMPID sort, then select the A1 cell to write the expression in the hyperlink expression: ". / showReport.jsp?rpx=/paixu.rpx¯o1=" + A1 + "& macro2=" + arg2+ "& arg2=" + if (arg2==1,-1,1)

Note: other cell settings are the same as A1.

After completing the above settings, you can click the header to switch the sorting of the column data.

On how to achieve big data report click header sorting needs to be shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.