string changing to number when pulling data from csv to crystal

[raja2008]

Hello Everyone!

Crystal reports XIR2

We have a report based on CSV file.I'm pulling the file through ODBC connection.

When it loads to crystal.

ONE of the field has text with numbers .
But crystal is lossing the text values ,it is only pulling the ones that are numbers,others are coming out blank.

Please help.

 

[raja2008]

Please tell if this the wrong place.

Should i be placing it in Data access forum

 

[SkipVought]

But crystal is lossing the text values ,it is only pulling the ones that are numbers,others are coming out blank.

This behavior is TYPICAL when you have a field that has MIXED DATA TYPES, like TEXT & NUMERIC.

You can 'fix' the problem by converting the numeric values to TEXT prior to accessing the data.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}