Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 15, 2015 at 09:35 AM

    Hi Roberto,

    Please have a look at Ken's blog here:

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded