EvaluateFormulasInDatabase Property

If True, formula filters and sorts will be converted to SQL when possible. The converted SQL statements will be placed in the WHERE (for formula filters) and ORDER BY (for formula sorts) clauses when querying data for the report. If set to False, all formula filtering and sorting will occur in-memory.

Due to innate difference between Exago's formula engine and SQL database engines, there may be discrepancies in data returned between two methods. Additionally, because the converted SQL formulas may contain arbitrary input, the connection string must be read-only access. For more information please see the Database Settings article.

Syntax

public System.bool EvaluateFormulasInDatabase {get; set;}

Property Value

True or False as described above.

Remarks

Same as setting Admin Console > General > Database Settings > Convert Formulas to SQL.

Property Value

Reference

Exago Knowledge Base