Error in File ****.rpt: The table could not be found in

Hi ,

I have a Crystal Report which uses a stored procedure to get it's data.

The stored procedure has no parameters but it is pretty complex and gives a resultset in the end with a select statement.

I designed the report in CR 11.5.12.1838.

The report works perfect in crystal reports designer.

Unfortunately I am getting an error in Central Management Concsole and InfoView

The error is:

Error in File ****.rpt: The table could not be found.

I am using ODBC connection and I even used to sa credentials to run the report in CMC but had no luck.

One thing I should mention that the stored procedure name as ;1 in the end.

I appreciate if you could help me with this report

Thanks