Condition

TOPICA Basic expression

The TOPICA Basic expression is evaluated - it should return a Boolean value.

false: The ReportTable is NOT shown in the report.

true: The ReportTable IS shown in the report.

HeaderText

String

Specifies a header text to be displayed in the report.

The text may contain embedded TOPICA Basic expressions in {...}. This is used to display "dynamic" information, e.g. from the context, the date interval entered by the user, the value of computed variables (for debugging), etc.

HeaderTag

String

The HTML-tag used for rendering HeaderText.

SQLQuery

String

The SQL query used to get data for the table.

The query may contain embedded TOPICA Basic expressions (in {...}. This should be used to make the SQL query "context sensitive", i.e. the SQL query must depend on the context, the report was started in.

The framework does NOT enforce any security when getting data. It is the report designer's responsibility, that the SQL used only returns data according to the context.

For example, when a report is started in the context of an organizational unit, the SQL must contain a WHERE-clause, so that the query returns only data "owned" by the organizational unit in context.

Note that reports, that may be started in the context of an organizational unit, also may be run as "system reports", where NO organizational unit is in context. Take this into consideration when constructing the SQL query.