Solved In the report display only value <>0 and blank for value = 0 (1 Viewer)

[Sokkheng]

In my report some field value = 0 and some value <>0, But now i want to display only value that <> 0 and value = 0 is blank, because i don't mess with 0 value.
Thanks for help.

 

[ebs17]

Replace 0 with NULL, ideally right at the beginning. The value 0 does not fall from the sky.

 

[Minty]

Value = 0 is blank makes no sense.

I think you want Value Is Null

 

[Sokkheng]

Value = 0 is blank makes no sense.

I think you want Value Is Null

Thanks for your reply, and how to replace value = 0 with blank, or how we can make conditional format if the value = 0 is change font color to white (only hide with white color) in the report.

 

[theDBguy]

Thanks for your reply, and how to replace value = 0 with blank, or how we can make conditional format if the value = 0 is change font color to white (only hide with white color) in the report.

Value Is 0

Try that in your CF condition and change the font color to white.

 

[Sokkheng]

Value Is 0

Try that in your CF condition and change the font color to white.

what is CF condition?

 

[theDBguy]

what is CF condition?

Conditional Formatting

 

[Josef P.]

You could also use the format property of the textbox and show nothing at 0.