CR 11 Field Cut off problem

[dzavad]

Hi,

I'm using Crystal reports XI to query mySql database. I've never encountered a problem before but I'm trying to run an old cr10 report and I'm getting some error messages.

It seems the field names are getting cut off at 21 characters. I came across a bug report from MYSQL(

http://bugs.mysql.com/bug.php?id=30965)

and it mentions database fields with underscores specifically.

I'm using the MySQL ODBC 3.51 driver, which I have always been using. I tried to move to 5.1 and received an error message.

Example problem I'm having:

Field "Location_of_Event_text" shows up in the Crystal field explorer as "Location_of_Event_"

Thanks

 

[smcnulty2000]

Well, since no one has bothered to answer this I'm going to offer the only idea that comes to mind.

Slip the fields into formulas and drop the formulas onto the canvas in place of the fields.

Sometimes you see weirdities that this solves because the field gets handled differently than the formula.

I've also seen a nice (similar) fix that involves dropping a text box onto the canvas and then dragging the field into that. Same kind of fix, really. You are bypassing a bug or flaw in the way one kind of thing gets handled by running it through a slightly different process that might handle it better.

Best of luck.