Crystal converting varchar 254 to memo

[vancoug]

Hi All,

We are still using Seagate Crystal Reports 7.5 for some of our reporting. I have a problem that hopefully someone can help with. One of our connections is to ODBC- AR System ODBC Data Source.
In that data source there are fields defined as varchar 254 (confirmed by DBA),
But Seagate is calling them memo fields- which is causing problems since you can't use memos in selection criteria or formulas.
This happened after the field names were renamed. I noticed when the newly named fields were not showing as an option to map the old name fields to- because by default it looks for same data type, after unchecking same data type option the fields showed for mapping but wrong data type makes them useless. I can't even convert them to string with formula field.
Any input would be greatly appreciated.

Thanks-

 

[IdoMillet]

If you can't move to a later version of Crystal, try a VIEW/SP in the database to cast the column to a string.

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com