BI Publisher for-each-group skip null columns in RTF template

Xavier P

Content

Hi All,

I have a scenario in RTF template, I need to perform for-each-group based on four columns.

<?for-each-group:G_ROWS;./COL1;COL2;COL3,COL4?>

COL1,COL2 and COL3 can be null but COL4 will not hold null values.

When I have null values in the COL1, COL2 or COL3, I need to skip that specific column in the grouping. Grouping needs to be performed on the rest of the columns.

Please let me know how to achieve the same.

Thanks,Xavier

Version

11g

Carlos Carvalho

Hello,

Can you add a sample xml so that anyone can test it?

Try:

<?for-each-group:G_ROWS;./COL1;COL2;COL3,COL4?>

<?if: /G_ROWS/COL1 !=’’?>

<?if: /G_ROWS/COL2 !=’’?>

<?if: /G_ROWS/COL3 !=’’?>

do your stuff here

<?end if?>

<?end if?>

<?end if?>

<?end for-each-group?>

 

And let us know.

Regards,

 

Carlos