How to supress NULL values in Text Object

[soha1902]

Hi All,

I have 3 fields Trainer, Trainee and Hours.

I am displaying all these fields in Text Object Using following expression:

=Concat(Trainer & '--' & chr(32) &

Trainee & '--' & chr(32) &

  Hours &

chr(13) & chr(13))

and it is working fine as I want but for some Trainee, Trainer is null so it is showing result like this:

-- Trainee1 -- 25

-- Trainee4 -- 30

My requirement is, I dont want to show those records where Trainer is not availabe. If I used any chart then simply we need to select Trainer dimension and then need to check "Suprees Null" but as per my requirement I need to display this in Text Box object only.

Please help me how to supress null values for Trainer as per above expression.

Thanks,

[Anonymous]

Hi Soha,

Find Attached solution.

Hope this will solve your problem.

Thanks

BKC

[soha1902]

Hi Jonathan,

How we use Distinct keyword inside this expression. In my application I have repetion of multiplwe values.

can you please help me.

Thanks..