surpessing accounts ending in zero

[chuchuchui]

Crystal XI

I'm trying to supress alphanumric account numbers that end with a zero, the alpha portion being at the front. An example would be, under the supress section {accountnumber] endsWith 0 though I know there is not endsWith but is there someway to accomplish that?

 

[synapsevampire]

Try:

right(trim({table.accountnumber}),1) = "0"

Rather than suppression, use the Report->Selection Formulas->Record. This will eliminate the rows from the report.

-k

 

[synapsevampire]

Oh, and the record selection would show the reverse, as in:

NOT(right(trim({table.accountnumber}),1) = "0")

-k

 

[chuchuchui]

Thanks, worked like a charm.