Use SQL Values in Reports

You can run complex SQL statements that are related to the current records and retrieve a single value. This is similar to the SQL label controls in the Form Designer.

For example, you can define an SQL value to display the value of a domain table (_TBD) instead of the value that is stored in the related table. If you have a Check Box value (Yes/No value), you can define an SQL statement for an Oracle-based enterprise industry model as follows: select decode({Active},0,'No',1,'Yes') from dual.