Advanced sort is pre-extended sort, which can only be sorted according to the data column or the formula that can be restored with the data column, the following we use the web report development tool FineReport to describe how to set advanced sort.
web report development tool FineReport7.1.1
Size: 148.2M Platform: windows/linux
Setting Method Select the cell with the data column, click the advanced button above the data column, and select the ascending or descending order in the sorting setting, as shown in the following figure: The default is no sorting, if you select the ascending or descending order, if you want to perform the ascending or descending order according to the current column, you do not need to fill in the formula; If you want to perform ascending or descending order according to other columns, you can fill in the name of the corresponding data column, which is called association sort.
Below, we take Details_1.cpt in the network format report as an example to see an example of order ids being sorted in descending order according to shipping costs.
Open template Open template: %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Primary\DetailReport\Details_1.cpt
Related content learned from experience
Effect view Click on the page preview, you can see the freight charges sorted in descending order: