Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question