error on crystal report 5.0 using SQL Server

I use Crystal Report 5.0 to do some reports. My database is in SQL
Server and my middleware is ODBC. In a Group Header, when I tried to
group the records by a specific field from a table, I got the error:

  ODBC erro: [Microsoft][ODBC SQL Server Driver][SQL Server] The Column
prefix 'tablename' does not match with table name or alias name used in
the query.

Does anyone know why??

Thanks,

Raquel Cunha
slcd...@ibm.net