String in non-numeric - Error

[bitsmith2k]

I've built a reporter utility using VB6 and CR8.5.

In it I've implemented a quasi Banker's Rounding algorithm that changes a
numeric value to a text value, then looks at the 1000ths digit. ie
2.4350 -> "2.4350" -> "5"

I then do my calculations based on that digit and and the 100ths digit.

My original problem stemmed from the way in which the fields were setup on
my machine. So i configured Crystal to have Number and Currency fields
carry four decimal places. Everything works the way I would've expected it
to.

Now I take my report to the client, point it at the server, and run the
report. The report runs fine on a machine that has CR8.5 installed on it
with all updates. So this is a good thing.

Our application is run through Citrix at the rest of the client site.
When I run the ICA application and try to generate the report I get the
above message. I've exhausted myself trying to figure out what to do here.
I've made sure all the regionalized settings allow for 4 decimal places in
currency and numbers.

The orig. application was build using a non updated CR8.5, so I'm assuming
that one(more) of the dlls is the culprit. I'd appreciate any info that
you guys can get me.



the number i am changing to text will always be a number.


Thanks

 

[akabatman2]

Hi Bit,

I've run into the non-numeric error before.

Did you mean the text you are converting will always be numeric text?

Did you try checking first to see if the field is numeric text?

IF NumericText({fieldtobeconverted}) THEN
ToNumber({fieldtobeconverted)) ELSE 0

Sometimes, you make think that the field will be numeric text, but if the database isn't fully populated with a number that can be converted to text, it results in an error.

I found this out when we checked the stored proc and the proc was bringing back data but the field to be converted was empty.

Hope that helps. If not, I don't know what else causes that error.

Tom

 

[bitsmith2k]

thanks for the reply,

its sales transactions that i am looking at so there will always be numeric non null data that i'm looking at.

the strange thing is that i get the error only when i run the report through a citrix connection.

if i open the report up in cr8.5 and run it on my machine through the designer it works fantastic..

mike

 

[Ngolem]

In it I've implemented a quasi Banker's Rounding algorithm that changes a
numeric value to a text value, then looks at the 1000ths digit. ie
2.4350 -> "2.4350" -> "5"

I am not familiar with this....is it a formula that you have developed that is causing the problem???

Usually when you get an error like this it indicates the problem formula

Please provide more information if you want this problem solved.

Jim Broadbent

 

[kenhamady]

If this is a formula error, post the formula.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com