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

Mike · Joined: 08 Aug 2007 Posts: 4

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

Archived from group: microsoft>public>dotnet>languages>csharp

Nicholas Paldino [.NET/C# · Joined: 08 Aug 2007 Posts: 71

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]
- mvp@spam.guard.caspershouse.com

"Mike" wrote in message @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 · Joined: 08 Aug 2007 Posts: 4

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]"
wrote:

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

Nicholas Paldino [.NET/C# · Joined: 08 Aug 2007 Posts: 71

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]
- mvp@spam.guard.caspershouse.com

"Mike" wrote in message @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]"
> wrote:
>
>>CDbl({pr_DajPonudu;1.KolicinskiPopust})/100 * {@NajamProstora}
>>>
>>> File KolicinskiPopust is carChar(25) within MS SQLEXPRESS DB

Mike · Joined: 08 Aug 2007 Posts: 4

All values are numbers from 0-100

On Wed, 12 Dec 2007 14:09:46 -0500, "Nicholas Paldino [.NET/C# MVP]"
wrote:

> 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# · Joined: 08 Aug 2007 Posts: 71

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]
- mvp@spam.guard.caspershouse.com

"Mike" wrote in message @4ax.com...
> All values are numbers from 0-100
>
>
> On Wed, 12 Dec 2007 14:09:46 -0500, "Nicholas Paldino [.NET/C# MVP]"
> wrote:
>
>> 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.

unique connection string problem I have written a generalised database access component which construct the connection string after decrypting its value using DPAPI methodology. But as i assign the enitre connection string to
OracleClient connection string problem in V1.1 I've installed the V1.1 framework and things have stopped working. Basically I can no longer get a connection to our Oracle 8.1.7 server with the 8.1.7 client software installed. It all worked fine with V1.0. If I use the same connection string in V1.1

ResetPassword() to Alpha-numeric? Hi, Is there any way to specify of the class to generate passwords of only alpha-numeric characters? Thanks, wb

Reflection: how to get numeric values from an enum? Using reflection to parse the type info in an assembly. For enums, how to get the constant values for the members? The field has the symbolic value, not the constant value. There's a HasDefault attribute but no mention I can find about *wh

Summing up numeric values using Oracle or T-SQL query Hi All, How to sum up the following numeric numbers in tag using T-Sql or Oracle query.There are thousands of tags rows in a column in the table. i need sum of numeric value present in the tag e.g. 2 tags shown below Tag 1: <