Memo Field in Crystal 10 Being Cut Off

[ToneV]

I am writing a report in Crystal Reports 10 which needs to pull in a memo field. When I preview the report, the field is only showing the first two characters. For example, the data should say "RIGHT SIDE" but it's only showing "RI". I have verified with the DBA that the data is correct for that field in the database.

 

[synapsevampire]

I should also have mentioned that you may be able to use a SQL Expression with a SUBSTRING type of fucntion to resolve this, again, this is databsae dependent, if you post in the future please be sure to include the basics.

What database and connectivity are you using?

We need technical information in posts.

If you right click the field and select format field->Common->Can Grow it should expand, otherwise it is likely a connectivity issue.

Soooo, post specifics.



-k

 

[ToneV]

I am using an ODBC connection to an Oracle database. I have created over 200 reports off of this database and this is my first memo field.

 

[synapsevampire]

Are you using the ODBC driver supplied by Oracle, or the ODBC supplied by Crystal?

It used to be that you needed to use the Crystal supplied ODBC, that may have changed in CR 10.

At any rate, create a SQL Expression of:

substr(table.field,1,100)

That will return the first 100 characters which will satisfy your requirements. If you aren't familiar with SQL Expressions, please read up on them, they are indeed your friend.

You can also use a CONVERT to another data type in a SQL Expression to get around some of these issues, but you didn't post what the Oracle data type is, Crystal shows all large string data types as MEMO.

-k

 

[satinsilhouette]

ToneV did you get this to work?

Thanks so much!
satinsilhouette

 

[ToneV]

After speaking to Business Objects, they determined that the problem lies in the ODBC connection. We seem to have trouble with blob and memo fields.

 

[synapsevampire]

I use ODBC with Oracle often enough, sounds like you have the wrong ODBC driver.

-k

 

[satinsilhouette]

That was what I was thinking as well synapse.

Thanks so much!
satinsilhouette