<div>
How about changing the two parms in the stored procedure from varchar to date.
</div>


How about changing the two parms in the stored procedure from varchar to date.

<div>
tried that still getting an error..
</div>


<div>
Just a short note: &nbsp;I am using NT4 and Crystal 8.5 is running on Win 2K. &nbsp;I am positive it is an ODBC issue and I really need a workaround... &nbsp;It only happens with Stored Procedures with parameters.
</div>


Just a short note:  I am using NT4 and Crystal 8.5 is running on Win 2K.  I am positive it is an ODBC issue and I really need a workaround...  It only happens with Stored Procedures with parameters.

<div>
<div class="content wysiwyg-content">
I am using Crystal Reports 6.0 but I have also tested on 8.5. &nbsp;I am running SQL Server 2000. &nbsp;<br />
<br />
I have a stored Procedure that has two varchar parameters (a date range).<br />
<br />
I have a report trying to report on the results of this stored procedure.<br />
<br />
Whenever I try to verify the database, it asks for the values of the parameters but when I put in the values that I used to test the Stored Procedure on SQL I get the following error<br />
<br />
ODBC Error: &nbsp;[Microsoft][ODBC SQL Server Driver]String data, right truncation<br />
<br />
I have requirement to use the ODBC driver so I cannot use Crystal's SQL driver.<br />
<br />
I am getting desperate. &nbsp;HELP!!
</div>
</div>


I am using Crystal Reports 6.0 but I have also tested on 8.5.  I am running SQL Server 2000.  

I have a stored Procedure that has two varchar parameters (a date range).

I have a report trying to report on the results of this stored procedure.

Whenever I try to verify the database, it asks for the values of the parameters but when I put in the values that I used to test the Stored Procedure on SQL I get the following error

ODBC Error:  [Microsoft][ODBC SQL Server Driver]String data, right truncation

I have requirement to use the ODBC driver so I cannot use Crystal's SQL driver.

I am getting desperate.  HELP!!

ODBC Error for a parameters from a Stored Procedure

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.