Crystal Reports: Add Command, select field from database AS STRING

[Former Member]

Hello,

I have a question.

I have a CSV database with some fileds inside of it.

I have a mixed type field: half of content is numbers type, half of content is string type.

Example:

FieldA; FieldB; FieldC

123; 123; aaa

456; 456; bbb

789; a99; ccc

Crystal Report recognise the field B as NUMBER and the walue "a99" will be blank on the report.

I want to import "fieldB" as a STRING, in every case, even if it contains only numbers.

How I can do that?

Regards

Roberto

[abhilash_kumar]

Hi Roberto,

Please have a look at Ken's blog here:

http://kenhamady.com/cru/archives/2461

-Abhilash