Variable length field not showing up in Crystal Reports

[ewithoud]

I have a problem with getting a variable length field to display properly in Crystal Reports 10.

I am working with CR10. Calling on a progress (mfg/pro) Database using ODBC (Datadirect 4.0).

In the database I have some fields that have a variable length. When these are passed to Crystal it will show as a string with 8 characters. 8 Characters is the standard schema of this field, however in the database these can be expanded lot more and are populated with data as wide as 50 Characters.

When I try to show these in crystal there is no way that it will let me see beyond the 8 characters. I have tried left() right(). It won't show more than 8 characters. When I check the field explorer on show field type it also shows up as a string of 8 characters.

Does anyone know how I can make it work so that the entire field is loaded as a longer string so I can work with it?

I have also posted this question in the CR forum, sorry for crossposting but I think it might be more of a progress / ODBC than a crystal question.

Thanks a million for helping me out.

Erik Withoud

 

[longhair]

ewithoud,
may be progress, at times it tries to assume what you are doing.
check to make sure that you are not triming the field.
can you put the data into a variable in crystal reports and display that?
regards,
longhair

 

[ewithoud]

I figured it out.

The version of progress being used does not allow this action.

an upgrade to version 9 is scheduled in the near future.