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

[Mike]

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

[Nicholas Paldino [.NET/C# MVP]]

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?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Mike" <ab******@yahoo.comwrote in message
news:b9********************************@4ax.com...

>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

[Mike]

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

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

Mirko

On Wed, 12 Dec 2007 11:14:59 -0500, "Nicholas Paldino [.NET/C# MVP]"
<mv*@spam.guard.caspershouse.comwrote:

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

>>
File KolicinskiPopust is carChar(25) within MS SQLEXPRESS DB

[Nicholas Paldino [.NET/C# MVP]]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Mike" <ab******@yahoo.comwrote in message
news:mi********************************@4ax.com...

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

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

Mirko

On Wed, 12 Dec 2007 11:14:59 -0500, "Nicholas Paldino [.NET/C# MVP]"
<mv*@spam.guard.caspershouse.comwrote:

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

>>>
File KolicinskiPopust is carChar(25) within MS SQLEXPRESS DB

[Mike]

All values are numbers from 0-100
On Wed, 12 Dec 2007 14:09:46 -0500, "Nicholas Paldino [.NET/C# MVP]"
<mv*@spam.guard.caspershouse.comwrote:

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.

[Nicholas Paldino [.NET/C# MVP]]

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?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Mike" <ab******@yahoo.comwrote in message
news:or********************************@4ax.com...

All values are numbers from 0-100
On Wed, 12 Dec 2007 14:09:46 -0500, "Nicholas Paldino [.NET/C# MVP]"
<mv*@spam.guard.caspershouse.comwrote:

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