Database Macros (6)
| Name | Description | Restriction | Compatibility | |
|---|---|---|---|---|
[Database.Connection:] |
Specifies a Database Connection. Specifies a Database Connection to use for the remainder of the report. Unless you are reporting on more than one Database system, you should not include a [Database.Connection:] Macro in your report. Instead, you can also create a Macro Parameter Default. |
|||
[Database.Graph:]UPDATED |
Retrieve SQL data and display in chart form in a report. Retrieve SQL data and display in chart form in a report. The query is executed via a Database Connection. |
Partial | ||
[Database.List:] |
Inserts values from columns from an SQL query as a list. Inserts values from columns from an SQL query as a list. The query is executed via a Database Connection. |
Partial | ||
[Database.Table:]UPDATED |
Inserts a table result from an SQL query. Inserts a table result from an SQL query. The query is executed via a Database Connection. |
Partial | ||
[Database.Value:] |
Inserts a single value from an SQL query. Inserts a single value from an SQL query. The query is executed via a Database Connection. |
Partial | ||
[Database.Values:] |
Inserts values from a single row from an SQL query. Inserts values from a single row from an SQL query. Every column must have a name. The query is executed via a Database Connection. Note that the column names are automatically stored as variables so a [String:] macro, for example, is actually required to view the value(s) returned. |
Partial |