Stored Procedure Connectivity Problem

Dear Friends

I am using crystal report 10 with sql server 2000 last many years. Usually i used stored procedures instead of tables. Yesterday all of sudden cyrstal report reutrned a message that "file name" not accessable and saved it as temporary file". Then i checked in "Document ans setting\..\..\local settings " folder where lots of temporary crystal reports exists. I deleted them all. After this i tried to re-create an other report, when i tried to open stored procedure from expert lint, i received an error "Query Engine Error: '22018:[Microsoft][ODBC SQL Server Driver][SQL Server] Syntax error converting the nvarchar value '%' to a column of data type int".

Crystal report returns this error in all procedures and all other database's procedures. I uninstall and installed twice but problem was exists there. Then i installed Crystal Report to an other computer, here also same message returned by crystal report.

Plese help as soon as possible, I am really stuck.

Thanks in advance.

I think that the problems is in the sql server side not in crystal side
Check your data

you are right its looking problem in server side, but what problem it could be?

Presumably somewhere you are trying to use a LIKE clause on a numeric field... that's the first place I'd look... see if you are using LIKE against a field that may be numeric....

-tg

What ever stored procedure i want to add in crystal report, at the time of adding it returned message which it quoted earlier. From any database any stored procedure the error is same. When i am adding table in crystal report it works fine.

Finaly i solved it, now i am posting the solution so that others can get benefit.

Actually problem with parameters, (I dont know why crystal report had problem with parameters). Simply i create a new procedure without parameter with simple select query. Then add into a new report, after doing this crystal report works fine.

Hi, we are having the same issue, the stored procedure is working fine within sql but in Crystal we are getting the error above, we need to keep the parameters in the stored procedure, does anyone know what is causing this issue or what the fix would be.
We are using SQL 2005 and Crystal Report XI, the stored procedure is a straight forward..... if parameter = G execute this procedure else execute another procedure.