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
Use a layout calculation like
If(ParamDisplayValue('Location') is null) then ('All') else (ParamDisplayValue('Location'))
Yes, answer is posted by gopinath.
Sometimes it favors case statement over if then else.