Using computed fields

Computed fields involve a lot of recalculation in many situations; for example, when a column is deleted, added, or renamed. This recalculation is a process-intensive task, which negatively impacts performance and can be worked around. Therefore, PowerServer recommends the following:

  • Avoid using computed fields in detail bands. Instead, add expressions in the SQL statements for getting specific data.

  • Avoid embedding a computed field in an existing computed field.

  • If a computed field is "Text: Sum or Expression", it is recommended that you divide the column into two columns: an edit style column with the "Text", and a computed field with "Sum or Expression".