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

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