x

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.

http://ask.sqlservercentral.com/questions/90620/combining-two-tables-with-different-data-type.html

more ▼

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

avatar image

meetpavi
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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x10

asked: Jul 02, 2012 at 08:49 PM

Seen: 1233 times

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

Copyright 2016 Redgate Software. Privacy Policy