How to trim ParamDisplayValue('Para1') that shows trailing spaces?

[lookingforK]

Hi,

I create a prompt page with a parameter 'Para1' that is supposed to be part of a dynamic title.

I add a Layout Calculation for the title, and use: ParamDisplayValue('Para1').

I run the report and find there are trailing spaces at the end of the string generated from ParamDisplayValue('Para1').

But I can't   use TRIM function to trim ParamDisplayValue('Para1'), i.e.:
I get error message when I use trim(TRAILING, ,ParamDisplayValue('Para1')).

How to deal with this issue and trim the string from the parameter?

Thank you in advance.

[Lynn]

Try this:

trim(TRAILING, ' ' ,ParamDisplayValue('Para1'))

[lookingforK]

Thank you Lynn,

I tried your expression...

But it could not work.

[Lynn]

The best thing generally is to provide any error messages or explanation about what didn't work.

I did not notice originally that you also omitted quotes around trailing. Try this. And if it doesn't work you'll know what to respond back with  ;D

trim( 'trailing', ' ', ParamDisplayValue('Para1') )

[lookingforK]

Thank you Lynn.

It works ... :)