Reporting > Native reporting system > Using fields as variables > Storing a selected value in a field for later use
  
Storing a selected value in a field for later use
You can specify SELECT field_1 AS field_2 to cause the value retrieved from field_1 to be stored in field_2.
The type of the field used as the destination does not matter; the type of the field it is compared with drives how the value is compared.
The selection level is stored in the target field. It is stored only when the level being processed matches.
Every field holds a copy of the last selected value.
See also
Using a field value in a WHERE clause
Selecting the last-stored value of a field in a SELECT statement
Parent topic
Using fields as variables