To add a Custom SQL field to a report, simply select the <Custom SQL Field> and click the [Add >>] button.
The <Custom SQL Field> appears in the Selected Data Fields section. Rename the Column Caption and populate the Formula field that appears when a calculated field is selected.
The following functions can be used for <Custom SQL Field>:
Things to note:
Only one <Custom SQL Field> can be added at a time
Custom SQL Fields cannot be referenced in other Custom SQL Fields.
Fields referenced in a Custom SQL Field do not need to exist in the report. To reference a field, place the field name within square brackets. E.g. to reference Assignment: ID use [Assignment: ID]. This is different than the Custom Calc Field where the Column Caption is referenced in the Formula field.
A Custom SQL field can be used to filter the report. This is not possible with a Custom Calc field.