Show ‘0.00’ on report instead of ‘null’ values?

7 July, 2011

Hi,

Is it possible to get the columns with no values to display 0 instead of blank?
I'm using a cross-tab report.

Thanks

Hi,

This should be possible by using the 'Display NULL as zero' option under the report data section of the report builder (see below).

Please let me know how you go.

Regards,
David

Hi David,

How do I display it as 0? instead of null?

I did set this option.

May I ask this as well? How come I couldn't set the display names as empty?

Before:

After:

Thanks.
HK

Also worth reading:

Forum