July 19, 201114 yr 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
July 19, 201114 yr 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.
Create an account or sign in to comment