handling null values

[dmasterplan]

Hi devs,'

I want my blank field to display anything I want in Stimulsoft report BUT it appears that it's not working.

I want the blank field to display 'X' in Stimulsoft when length is zero or NULL.

I have a query:

Code: Select all

CASE WHEN len(cmrev.code) = 0
THEN 'X'
ELSE cmrev.code
END 'code'

Thank you!

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.