There is a safety mechanism to prevent report processing from hanging due to an infinite loop. Any one evaluation of a formula can have at most 30,000 loop condition evaluations per formula evaluation. For example:
Dim i i = 1 Do While i <= 100000 If i > {movie.STARS} Then Exit Do i = i + 1 Loop formula = 20
If {movie.STARS} is greater than 30,000 then the loop condition (i <= 100000) will be evaluated more than the maximum number of times and an error message is displayed. Otherwise the loop is OK.
Note: The safety mechanism applies on a per formula base, not for each individual loop. For example:
Dim i i = 1 For i = 1 To 10000 formula = Sin (i) Next i Do While i <= 25000 i = i + 1 Loop
The above formula also triggers the safety mechanism since the 30,000 refers to the total number of loop condition evaluations in the formula and this formula will have 10001 + 25001 such evaluations.
Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com |