Changing Field Types?

[ProgEval]

I am creating a Crystal Report (10) on an Excel file. The Excel file has a particular field formatted as Text (includes both numbers or character records). Although, when Crystal links to the file it bring this field in as a number and eliminates all character records in the field.

Any suggestions on how I can bring this field into Crystal as text?

Thanks.

 

[IanWaterman]

Crystal will interpret based on first datatype found.

When designing report make sure first record is text. It should then remain text then whatever happens to future excel spread sheets. (Unless you verify the report again)

Ian

 

[lbass]

Please see thread149-1516532.

-LB