Display a subset of field values in text object

[#1]

Hi all,

Using a text object, I want to list all values for a given field, say field_1, where field_2='x'.

Any ideas?

I thought I could do the following expression would work but no luck:

   =if(field_2='x', field_1)

Regards

Revlin

[giakoum]

try something like this :

CONCAT(DISTINCT if(field_2='x', field_1)  ,' - ',if(field_2='x', field_1)) )

[rwunderlich]

How about:

concat ({<field_2={x}>} field_1, ',')

-Rob

[#4]

That works great actually. Thanks

Instead of a '-' how can I add a carriage return in between?

[#5]

Got it I just add the chr(10).

Thanks a bunch guys!