11-30-2007 1:08 PM
Hi all,
Please give me a solution to the below problem.
Im executing an interactive report is executed for extracting the total cost value of product hierarchy, at first time the total cost is correct.
But when we go back from 5th list to the 4th list and once again select the part number for viewing the total cost doubled and shows the incorrect cost for the part number.
If once again I go back and select the part number to view the cost, then the cost value is Thrice to the original value and shows the incorrect cost for the part number.
Thanks,
Kanth
11-30-2007 1:09 PM
Hi Kanth,
The cost value needs to be cleared (initialized to zero) each time an action is performed.
Use a CLEAR statement to clear the variable at the beginning.
CLEAR <var1>
This will always initialize the value to zero every time an activity takes place, and the value will not get doubled or tripled.
Cheers.
11-30-2007 1:13 PM
Robin,
You are not clearing work area after modify or append statements. That is why you are getting double values.
It is always good to clear the work area when ever you use Modify or append statements.
Regards,
Satish
11-30-2007 6:59 PM
Have you tried using the Debugger to see the Values before and after they are loaded? A very resourceful tool when you need to monitor values.
11-30-2007 7:04 PM
I guess its definitely a refresh or a clear problem. looks like more of a refresh problem of the internal table.
Please try to refresh the Internal table everytime you do the interactive processing.
Shreekant