Error by transfer input parameter to stored proc
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4996
Printed Date: 28 Apr 2024 at 10:59pm
Topic: Error by transfer input parameter to stored proc
Posted By: ops5
Subject: Error by transfer input parameter to stored proc
Date Posted: 12 Dec 2008 at 1:50am
|
Hello.
I use Crystal 11 R2 SP3 and Sybase 15
I want to use stored procedure for my report.
This procedure have one input parameter of datatype int.
When I choose this procedure as dataset,a window displays, where I
am ordered to enter input parameter.
For example,I input 2.
Crystal dispays error :
"22018 Implicit conversion from datatype varchar to int is not allowed.
Use the CONVERT function to run this query " I input convert(int,'2').
There is same error.
Thanks..
|
Replies:
Posted By: ops5
Date Posted: 15 Dec 2008 at 2:36am
|
I solved this problem.
It need to change DataSource from ODBC to Open Client(server Sybase)
Now it all is ok
 |