universe data error when trying to create a Crystal Report

building semantic layer
1

I am trying to build a report from a universe in Crystal 2008. I am trying to add region to my report but get the error “non-numeric character was found where a numeric was expected”. Region is a string, so I do not know why it is giving me this error. When I connect directly to the table (not via the universe) and add region, I do not get the error. In the universe the region is stored as type character and is a dimension. Does anyone know why I am getting an error?
Thanks.

knew :us: (BOB member since 2009-09-08)

2

Check the joins in your universe. I see this error sometimes if my joins are incorrect, for example if I make a mistake and join region_id to a character field in another table.

Dave Rathbun :us: (BOB member since 2002-06-06)