Deriving a Result Set from Query Columns
In some cases you may need to calculate the data you want to display from existing query columns. To do this, modify the formula by placing '=' in front of the expression string.
For example, consider the formula table described previously (Referencing a Query Column). To merge the 'state' and the 'zip' fields into a single cell, separated by a comma (e.g., NJ, 08901), use the following formula:
q['=state + ", " + zip'];

| << Referencing a Query Column | © 1996-2013 InetSoft Technology Corporation (v11.4) | Referencing a Query Column With Field Filtering >> |