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 184.108.40.2068.
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