Variable length field only shows first 8 characters

[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 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 of this field, however in the database these can be expanded 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?

Thanks a million.

Erik Withoud

 

[dgillz]

Click on database, verify database. See if it reads a new data length.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[dgillz]

Other than crystal, what outside confirmation do you have that this field is up to 50 in length? I don't know anything about progress databases, but can you browse the database definitions and confirm this?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[ewithoud]

Normally if you would query the data in progress it will only show the 8 characters.

However what I've seen done in progress is the recoding of the format of the normal Schema.

So when a variable is set-up as X(8) you can recode it to X(40) and then query it, this way it shows much more.

However I am not sure Crystal or ODBC knows how to handle this. I think it just looks for the standard schema and imports the table correspondingly so it just looses all the data somewhere between the database and Crystal.

Sorry that I can't be clearer I'm not a progress guy.

Surely something similar must happen with other database types?

 

[ewithoud]

Should I maybe post this in the progress section as well or is that not allowed?