Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL Text fields truncating on report in Crystal 9 1

Status
Not open for further replies.
kernal

kernal

Technical User
Feb 27, 2001
415
US
I'm connecting to a mysql database through ODBC (RDO) and using Crystal 9. I have Can Grow checked and maximum number of lines at 0.

I have 4 text datatype fields in the mysql database and when I have my mouse on the field in Crystal 9, it reads them as memo fields.

Memo fields are truncating and not at the same number of characters on the report.

One memo field is only showing up to 275 on some records and 276 on other records.

Another memo fields is only showing up to 240 characters.

Another one is only showing up to 145 characters.

The last one is only showing up to 105 characters.

This is very strange. Any ideas what could be happening.

Thanks

P.S. I connect to CSV files in reports and long description fields are showing up fine in Crystal 9.
 
Sort by date Sort by votes
Yeah, Crystal supports > 254 chars in CR 9 and above, so that's not the issue.

Could be the ODBC connection.

I'm not too familiar with MySQL, I know that they have text and ntext (unicode), but you might try using a CAST or CONVERT statement in a SQL Expression to create a field type such as char or varchar in MySQl supports those and see if that brings back all of the data.

-k
 
Upvote 0 Downvote
Thanks synapsevampire. I'll try your suggestion.
 
Upvote 0 Downvote
I tried to create a sql expression for these fields but in the SQL Expression Editor, the memo type fields are not showing as a field that you can use.

 
Upvote 0 Downvote
Thanks synapsevampire. I thought the fields had to show in the editor but with your help, now I know different. It worked great.
 
Upvote 0 Downvote
I stumbled across a hot fix on the Business Object support webpage and now it looks like all of the mysql text is showing and exporting to Excel without using sql expressions. That's one victory for today.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
493
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
738
hilfy
hilfy
D
  • Locked
  • Question
Open a report into Design mode
Replies
0
Views
154
drb1980
D
D
  • Locked
  • Question
Crystal Reports for Visual Studio 2022 Download
Replies
2
Views
5K
Joshua44
J
smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
407
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top