To get data to be printed in the report, its possible to define SQL queries.

These queries are similar to the ones performed in the SQL advanced action.

Name – Name of the query.

Query – SQL Query.

Database Profile – Database connection profile used when running the query.

TARGETS

Column – Name of the column to retrieve.
This parameter is merely informative and has no impact whatsoever. What matters is the index of the Column. Therefore, this refers to the first returned Column.

Target – Report Variable where to save the value of the first Column.