performance speed up

[jibardhan]

how to speed up a report containing a lot of fields having unstored calculation fields

and the calculations field contains definition of other calculation fields

[bcooney]

One way is to create stored fields that are set to the calc'd values, perhaps overnight in a server script (if it's acceptable to have the report data "as of last night"). Another way is the script using transactions and always have stored values, rather than relying on FM's aggregrate functions.