I am using a matrix report. Column type is string. I have a different values: sometimes '123' sometimes 'textabc'.

but when I try to do sht like this:

if NumericText({db.value})
    then
       "number"
else
    "string"

it always check only the first record (i think) and if there is 'textabc' everything in that column is string. and in reverse, if there is '123' everything is 'number'.

How can I get 'string' value where is 'textabc', and number where is '123' ?