I'm trying to make a new custom report that pulls data out of the extrafielddata table. The Value field is of type longtext but actually has an integer in it in this case. I want to form a relationship with another field in the users table but it's of type integer so there's a type mismatch. Anyone know how you can form relationships of mismatched fields of different types? We tried a custom SQL query as the data source that does a CONVERT but that didn't work.