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 '12 at 08:49 PM in Default

meetpavi gravatar image

meetpavi
40 4 4 5

@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 '12 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x7

asked: Jul 02 '12 at 08:49 PM

Seen: 768 times

Last Updated: Jul 05 '12 at 06:13 AM