Formula execution order

[Former Member]

I have several formulas and fields defined in the details section.

is there a document that describes the order in which formulas are executed, when placed in the details section ?

can i assume that if i want a specific formula to execute after all the others i have to add:

evaluateafter(formula #1);

evaluateafter(formula #2);

etc, etc for all other formulas

i have a formula that resets a few global variables used by the others(therefore has to execute last). all formuals are in the details section.

thanks in advance John

[abhilash_kumar · Accepted solution]

Hi John,

A Crystal Report executes in the left-to-right top-to-bottom fashion. So, formulas placed in higher sections execute 'early', again, depending upon whether they're 'whileprintingrecords', 'whilereadingrecords' or 'beforereadingrecords'.

If you wish to force formulas placed in the same section to follow an execution pattern i.e formula 1 after formula 2, formula 4 after formula 1..., then you're right, you would need to add 'evaluateafter (formula)'.

I'm not aware of any document that describes the order of formula execution, however you could still try searching in the Crystal help (F1).

Hope this helps!

-Abhilash