CrystalReports, c# - The string is non-numeric problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 12 Dec 2007 13:59 GMT

I use MS SQL EXPRESS DB
VS 2005, c#
Win Application

I have problem "The string is non-numeric"

with formula

CDbl({pr_DajPonudu;1.KolicinskiPopust})/100 * {@NajamProstora}

File KolicinskiPopust is carChar(25) within MS SQLEXPRESS DB

I found description error and possible solution:
The string is non-numeric.
The argument to the ToNumber function must be a number stored as a
string
(for example, a customer number, an ID number, and so on). The string
may
be preceded by a minus sign and may contain leading and trailing
blanks. You
have used an argument that is non-numeric and therefore cannot be
converted to a number. Change the argument to numeric and recheck.

How I can reslove that?

Thanks

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 12 Dec 2007 16:14 GMT

Well, what is actually in this field? The report is seeing a
non-numeric value.

Are you sure that there are no non-numeric values being passed to this?

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

>I use MS SQL EXPRESS DB
> VS 2005, c#
[quoted text clipped - 22 lines]
>
> Thanks

Reply to this Message

Mike - 12 Dec 2007 17:13 GMT

Within DB "pr_DajPonudu;1.KolicinskiPopust" is VChar(25) and
@NajamProstora is int

CDbl({pr_DajPonudu;1.KolicinskiPopust})/100 * {@NajamProstora}

Mirko

>CDbl({pr_DajPonudu;1.KolicinskiPopust})/100 * {@NajamProstora}
>>
>> File KolicinskiPopust is carChar(25) within MS SQLEXPRESS DB

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 12 Dec 2007 19:09 GMT

No, I meant, what are all the values for that field. If you don't have
a lexical representation of a number, you won't be able to convert it, and
get the error message you are getting.

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

> Within DB "pr_DajPonudu;1.KolicinskiPopust" is VChar(25) and
> @NajamProstora is int
[quoted text clipped - 6 lines]
>>>
>>> File KolicinskiPopust is carChar(25) within MS SQLEXPRESS DB

Reply to this Message

Mike - 13 Dec 2007 09:30 GMT

All values are numbers from 0-100

> No, I meant, what are all the values for that field. If you don't have
>a lexical representation of a number, you won't be able to convert it, and
>get the error message you are getting.

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 14 Dec 2007 02:09 GMT

That's the thing, they aren't, or crystal reports doesn't see it that
way. Either that, or the binding is incorrect.

I've also seen bindings on crystal reports (in earlier versions) just
get messed up, and map the wrong fields to the wrong bindings. If you
verify the data for the report (or outright change the data source and then
change it back) do you still get this?

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

> All values are numbers from 0-100
>
>> No, I meant, what are all the values for that field. If you don't
>> have
>>a lexical representation of a number, you won't be able to convert it, and
>>get the error message you are getting.

Reply to this Message

CrystalReports, c# - The string is non-numeric problem

Free Magazines