Creating reports and dashboards | Stimulsoft community forum

Posted: **Mon Aug 22, 2016 10:25 pm**

Is it possible to display a specified character in a crosstab when the value is NULL/zero? Similar to the option that exists on a data field. Here's an example of how output currently appears and how I'd like it to appear.

: Crosstab current.jpg (7.98 KiB) Viewed 1635 times

: Crosstab wanted.jpg (8.53 KiB) Viewed 1635 times

Thanks,
Sabrina

Posted: **Tue Aug 23, 2016 10:04 am**

Hello.

Yes, it's possible. You could do this with Conditions.
Check if value == 0 and Assign the expression.

: value0.png (12.93 KiB) Viewed 1630 times

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Crosstab: show character in place of NULL/Zero value

Crosstab: show character in place of NULL/Zero value

Re: Crosstab: show character in place of NULL/Zero value