"Option loop" in a report custom function

[patrick_simons2]

Hi,

I have a larger formula code from a 3rd party supplier I use in a normal CR formula. This works well.
This formula contains the line "Option Loop 10000000".
According to you help : "The Option loop statement can be used to specify the maximum number of loop condition evaluations per evaluation of a formula. This statement should only be used when the default maximum loop count of 100,000 is not sufficient for the given formula."

Now I need to move this formula code inside a new report custom function like this:

Function ieIDAutomationFontEncoderQR (DataToEncode As String) As String
Option Loop 10000000
...

In this case the syntax check returns "A statement is required here".

PS. I'm using CR 2020 SP4 P1

Any workaround?

Thanks.
Patrick

[JWiseman · Accepted solution]

Hi Patrick, most likely Option Loop is not available for use inside a Custom Function. In the Formula Workshop, if you compare the Operators > Control Structures for Report Custom Functions vs Formula Fields, the "option loop maxiterations" is only there for Formula Fields.