Table Field

[Jonathan212]

Example of Selection Criteria:
{@SurgDate} = {?Date} and
isnull({pcmprocedure.deletedon}) and
{pcmProcedure.primaryProcedure} = "Y" and
isnull({pcmcase.deletedon}) and
isnull({pcmanesthes.deletedon}) and
{pcmCase.status} = 3 and
tonumber({vw_pcxPatient.medicalRecordNumber}) in [
471823 ,
967138 ,
670587 ,
958754 ,
858620 ,
754679 ,
368877 ,
975928 ,
978406 ,
343797
]

I entered that vw_pcxPatient.medicalrecordNumber information in selection formula > record and then entered {table field} in [paste here]

Getting error message: the string is non-numeric

The medical record number is a string.

Any thoughts as per how I can resolve this error message?

Using Crystal 10.

Jonathan

 

[lbass]

Why are you converting it to a number? It sounds like the field might have nulls, spaces, or alpha characters in it.

You could try changing the last section to:

isnumeric({vw_pcxPatient.medicalRecordNumber}) and
tonumber({vw_pcxPatient.medicalRecordNumber}) in [
471823 ,
967138 ,
670587 ,
958754 ,
858620 ,
754679 ,
368877 ,
975928 ,
978406 ,
343797
]

-LB

 

[Jonathan212]

Thank you Professor LB. Perfecto. Most appreciated, timely and extrenmely helpful.