Query returns big result cause dump in report, any solution?

[Former Member]

I'm working with report and it returns big result cause the following dump. Any suggestion for this problem? thanks !

An overflow has been determined in the current arithmetical operation

containing operands of type P. Possible causes include:

1. The results field of type P is to small and the result does not fit

into it.

places.

2. The result or partial result has more than 31 decimal places.

[Former Member]

Hello

And as they were declared variables ?

[naveen_inuganti2]

Hi...,,

Did you declared that variable as..

data: r type p decimals N.

?

Let me know.

Naveen Inuganti.

[Former Member]

Thanks, I found out the problem, it is is the dummy data cause the exception of a calculation. I declared a variable in decimal type with the length is 11 and the result of the calculation is too big so it is overflow. My question now is how to catch that exception of the calculation without using try and catch because my version of does not support try ... catch yet. Thanks!

[Former Member]

I found it thank you very much for helping me.