Displaying field values in a Text Object

[Anonymous]

How do I write an expression in a text object to display the name of a salesperson for a specific region.  I want the region in the text object to be fixed to 'Europe'.

Thanks

Greg

[lvf · Accepted solution]

Try this....

=Concat({$<Region={'Europe'}>}SalesPerson, ' ')

[tresesco]

With a distinct key, like:

=Concat({$<Region={'Europe'}>} Distinct SalesPerson, ' ,')

[maxgro]

=concat({$<region={Europe}>} distinct salesperson , chr(10))