Creating reports and dashboards | Stimulsoft community forum

Posted: **Sat Sep 17, 2022 7:39 am**

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!

Posted: **Mon Sep 19, 2022 11:50 am**

Hello,

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

Thank you.

Creating reports and dashboards | Stimulsoft community forum

handling null values

handling null values

Re: handling null values