Hide Null values @column

Hello All,

I’m in need of help on achieving something using RTF template.

I have a column called “FOCO” where the first value is NULL, and all the others would be “Fiscalizacion”, “Servicios” and “Apoyo”, repeated several times.

So if I use a

<?for-each-group:/DATA_DS/G_1;./FOCO?>

<?if:FOCO!=''?> <?FOCO?> <?end if?>

<?end for-each-group?>

It will show me the rows Without the null:

Fiscalizacion

Servicios

Apoyo

But if I want to show them as columns:

<?for-each-group@column:/DATA_DS/G_1;./FOCO?>

<?if:FOCO!=''?> <?FOCO?> <?end if?>

<?end for-each-group?>

Below you'll see the results for both examples