Crystal Report Error

Hi Can some one tell me the reason fr the following error? I use the above code and linked it to a stored procedure to use it in a crystal report. I get an error saying

Query Engine Error: 'ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Error Converting data type varchar to numeric. SQL State:22018 Native Error: '

Thank You So much for your help.


more ▼

asked Jul 02, 2012 at 08:49 PM in Default

avatar image

50 4 4 7

@meetpavi It seems like you are mapping varchar data type to numeric which resulted in such error. Make sure that there are valid numeric values stored in the varchar column.

Jul 05, 2012 at 06:13 AM Usman Butt
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 02, 2012 at 08:49 PM

Seen: 1292 times

Last Updated: Jul 05, 2012 at 06:13 AM

Copyright 2018 Redgate Software. Privacy Policy