Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 17 September 2017

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?>

Sort data in xml reports

 Output:




Sort data as descending based on Empno:


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

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


Sort data as descending

 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?>



Share this article :

0 comments:

Post a Comment