Sort Data in BI/XML Publisher Reports

You can sort data in XML report a group by any element within the group.

Sort data based on Empno:

Syntax: 

<?sort:Field_Name?><?Field_Name?>

It sorts the data in ascending order by Default. If Order By is not mentioned

Example: 

<?sort:EMPNO?><?EMPNO?>

 Output:

Sort data as descending based on Empno:

Syntax: 

<?sort:Field_Name;'descending'?><?Field_Name?>

Example: 

<?sort:EMPNO;'descending'?><?EMPNO?>

 

 Sort data based on Ename Test Element:

Syntax:

<?sort:Field_Name;’Order by’;data-type=’text’?>

It sorts the String Data based on Order By mentioned here like Ascending Or Descending

Example: 

<?sort:ENAME;’ascending‘;data-type=’text’?><?ENAME?>