Exago .NET API Documentation
EvaluateFormulasInDatabase Property
WebReports.Api.Common Namespace > General Class : 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.
public System.bool EvaluateFormulasInDatabase {get; set;}

Property Value

True or False as described above.
Same as setting Admin Console > General > Database Settings > Convert Formulas to SQL.
See Also


General Class
General Members

Exago Knowledge Base

Database Settings
Converting Formula Sorts to SQL