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!!