Precautions for use of Birt

Sometimes it is necessary to sort the data when using Birt:

General sorting uses the sorting property of the control directly to sort in a positive and reverse order

But to put a piece of data in front, you need to classify the data when the SQL statement is introduced into the result bounds.

Examples of categorical statements:

SELECT case when T1. Due_dt<t1. Data_date then 1 ELSE 2 END as aa_sort

, T1. Report_date

, T1. Due_dt

, T2. Curr_cd_name

, T1. Subordinate_account

, T1. Tradetype

, T1. Amt

From RPT_FX_POSITION_PTB T1

Left JOIN TEST T2

On T1. CURR_CD = T2. Curr_cd

ORDER by T1. Due_dt ASC

This time the results set can be sorted according to Aa_sort , but the results will not be shown.

Precautions for use of Birt