How do suppress row in the loop in xml Publisher reports
if the data in the emp table is like
EMPNO ENAME SAL
1001 XYZ 1100.00
1002 ABC 200.00
3000 DEF 1200.00
If client wants report
like this first want to print all employees data(without suppressing )
second want to print employees who has salary more than 1000 USD
without suppressing
<?for-each:/ROWSET/ROW/?>
<?EMPNO?><?ENAME?><?SAL?>
<?end for-each?>
With suppressing
<?for-each:/ROWSET/ROW/[./SAL>1000]?>
<?EMPNO?><?ENAME?><?SAL?>
<?end for-each?>
