Data comes into Report with "_b" for a space

[honorbum]

We are in the middle of setting up Crystal Reports 2008 and using it to pull data from a ticketing database for export into excel. When we run the report the blank spaces between words appear as an "underscore b" (_b). We're using Mysql 5.0 ODBC connection.

Can someone tell me what is causing this and how to get rid of it? Is it in the database the data is being pulled from or is it somethning added in the transfer of data?

Also need to note, when running reports from the ticketing database (the application itself) then the field data appear normal.

Here's an example pulled from the exported excel file:

Ticket__bType Category
Trouble Application__bServices


Thanks,

 

[Madawc]

I've no idea why it's happening. You can get rid of it using a formula field,

Replace({your.field}, "_b", " ")

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[honorbum]

Thanks, I will try that out.

 

[honorbum]

The formula works fine however I have to put that formula into every string field in the report which is a pain. (like 20+ fields)

If anyone else has a fix for the _b issue, please feel free to suggest.

Thanks

 

[lbass]

I don't really know anything much about drivers, but it seems like it could be a driver issue. Years ago, I tried a driver that appended ".00" to fields, even to strings. I have nothing more I can add on that, though.

-LB