Surpressing data, if ....

[jellybead]

Hello All,
We are using CR8.5 and I am trying to eliminate records if the string DATA is part of the part number field, AND the unit price is 00.00.


This is what I have so far, but it won't work.

IIf ({CNX_DELIVERY_PERFORMANCE\.SALE_UNIT_PRICE}="000")and ({CNX_DELIVERY_PERFORMANCE\.CATALOG_DESC}="*DATA")
then ""

Any suggestions would be greatly appreciated.

Thanks, Jellybead

 

[synapsevampire]

That does "This is what I have so far, but it won't work." mean? Getting errors? Wrong results? Won't work isn't descriptive.

Try going into the Report->Edit Selection Formula->Record and use:

not((
{CNX_DELIVERY_PERFORMANCE\.SALE_UNIT_PRICE}="000"
)
and
(
{CNX_DELIVERY_PERFORMANCE\.CATALOG_DESC} like "*DATA"
))

-k