how to hide a report builder field if it is zero

[scottnweber]

I am using Coldfusion Report Builder. If the value of a feild is zero, how can I hide it or show a blank. Keep in mind this field is a DollarFormat() field.

[EddieLotter]

scottnweber wrote:

I am using Coldfusion Report Builder. If the value of a feild is zero, how can I hide it or show a blank. Keep in mind this field is a DollarFormat() field.

When you click on the field in Report Builder, look near the bottom of the Properties window, in the "Print Control" section.

You will see an entry labelled "Print When Condition". Put an expression next to it that returns true or false.

For example, in your case, you would put something like the following:

MyField neq 0

Where "MyField" is the name of your field. This expression will only allow the field to be printed when its value is not zero.

Since you're targeting the value of the field you don't have to worry about the formatting that you used next to "Expression" in the "Data" section of the Properties window.

[scottnweber]

That sounds excellant Eddie. This is exactly what I was looking for. Thank you!!

[EddieLotter]

scottnweber wrote:

That sounds excellant Eddie. This is exactly what I was looking for. Thank you!!

You're very welcome.

Please mark this thread as answered for the benefit of other users.