crystal 8.5 numbervar overflow???

[mbasimon]

I have a running total using a shared numbervar variable. However, once this number gets to about 1,000,000, it stops acting normal.

For example, in this one report, the first 20 or so additions are fine. The number will get to 978,664. If I add 63,327, it now shows 1,041,991. So far so good. However, I then add 98,495 and it comes up with a total of 1,077, 159. It added it to the 978,664 instead of the 1,041,991. Then next line is to add 127,653 and again, it incorrectly adds it to the 978,664 to come up with 1,106,317.

Has anyone seen this kind of action before?

Thanks.

 

[CrystalStart]

Can you describe addition process? Who adds what to where?

 

[mbasimon]

There's a variable reset in the group #1 header. The summation takes place in the group #2 footer. It adds the value of a database field to that variable.

 

[synapsevampire]

Seems strange to me...

I would suspect something else, and also apply the latest service pack:

http://support.businessobjects.com/fix/hot/si75/default.asp

If all else fails, either try using it in a conventional formula instead of a Running Total, or multiply everything by .001 until you're done with the calculations, then divide it by .001

Since you've posted nothing about what the RT is doing, I can't suggest anything very technical.

-k