Preventing 0 value from printing 1

[pineisland99]

We have this formula placed in our group footer
NumberVar SaleCount;
if UCase({external_sales#sales}) = "Sold" then
1
else
0

We have inserted the formula into a group footer, and it prints results accordingly.

How can we prevent the formula from printing if the value is 0.
Ideally, we don't want the group to print at all if there is a value of 0

Appreciate the assistance

 

[synapsevampire]

Placeit in the rEPORT->sELECTION fORMULKA-rECORD:

not(UCase({external_sales#sales}) = "SOLD")

I doubt that this willpas to the database though, you should create a SLQ Expression which does the ucase function on the field, and then reference it in the record selection.

-k