I'm running Pentaho BI Server and added a mysql data source. I've managed to get a few reports working with simple tables but I'm having a problem with columns with data type - blob.
When a column of a "blob" data type is used in the report it just shows up as number and not text.
Any ideas?
So I guess that the simple answer to all this in my cause was to change the "blob" datatype to "text". Since I was not using the "blob" to store any binary.