CODEWITHSUNDEEP
crystal-reports
antonis lambrianides
antonis lambrianides

Reputation: 423

Crystal Report exclude only numeric values

On crystal reports i want to add a filter in formula editor to exclude any value that has only numbers. I have a column which is car registratios and i dont want to load any data from where this carReg has a value with only numeric.

Ex. 123456, KKT 689, KRT 254, 521684 I want to show only the KKT 689 and KRT 254.

I have this already done in my database in an sql statement. But ill move the filter into the crystal report and i dont know the syntax for doing this in crystal.

Any ideas people? Thank you

Upvotes: 0

Views: 1283

Answers (1)

Zeina
Zeina

Reputation: 1603

You can add a new formula, and write in it the following:

if IsNumeric({carReg}) then 
  ""
ELSE 
  {carReg}

This formula suppresses the Numeric Car Registration numbers.

Upvotes: 1

Related Questions