How are queries defined in report scripts?

You use queries to evaluate certain data elements for your report. A query searches a selected dataset and returns the data elements found for output in the report. You can use various filters to further restrict the number of data elements output. In report scripts, you can insert a query into an existing query, directly into a section, or into a data table.

A static area is available for queries for which certain values of the data elements found should only be output once, for example, for output of an individual item, a list, or a chart.

The repetition area is available for a query for which certain values should be output for each individual item of the result set, for example, for the names of all EPCs in the selected groups.

In data tables, the individual values of queried data elements are listed in table format. For each data element found, a line is inserted, in which the relevant values can be output.

Data fields or charts are used to output the relevant values (for example, function names) of the data elements found.

Queries can be nested by inserting up to a maximum of five subordinate queries. On a hierarchy level, you can create as many queries as you like.

Example

Queries in a report

See also

Structure of report scripts in the design view

Insert queries into report scripts

How are data elements specified for evaluation?

Set filters for queries in report scripts

Use case: How to work with report script templates