ParamDisplayValue('.......')

[Jeka]

Hello,

Im using ParamDisplayValue('Location') in te report header.
This prompt is optional, so when the user is not selecting anything for Location, it will show Blank in ParamDisplayValue.

Is it possible, if blank, then display 'ALL'?


Thank-you for your help!
Nikki

[Gopinath]

Use a layout calculation like

If(ParamDisplayValue('Location') is null) then ('All') else (ParamDisplayValue('Location'))

[Suraj]

Yes, answer is posted by gopinath.
Sometimes it favors case statement over if then else.