Matching a Number and String Field

[enbw]

Hi,

I am writing a report based on a 3rd part product. I have two fields in different tables, one defined as a string and one defined as a number. I need to be able to match these up in the select expert. Is there anyway to do this?

Thanks in advance

 

[pgtek]

Hi

you have to convert one of them to sring or number

create a formula for this
@vonvert

totext({your_field})

cheers



pgtek

 

[synapsevampire]

You have options.

The most efficient would be to create a SL Expression out of one of the fields:

//create a number from a string:
cast(table.field as numeric)

//create a string from a number:
cast(table.field as varchar(32))

The above is database and Crystal version dependent, not sharing this information will limit responses.

Or within Crystal you would create a formula (Insert->Field Object) and place something like:

//create a number from a string:
val(table.field)

//create a string from a number:
totext(table.field,0,"&quot

-k