You can insert queries into individual sections of a report script. Queries allow you to specify the data elements that are evaluated when a report is run.
You can insert queries directly in sections or using a data table. You also have the option to nest queries by inserting subordinate queries into a query.
Procedure (quick video)
You can set queries for both the repetition area and the static area of each section.
You can insert only one query into the repetition area.
In this way, you can insert multiple queries into the static area.
Depending on the selected data element of a query, different filters are available to you here.
Depending on the selected data element of a query, different sorting criteria are available to you here.
The queries are inserted into the selected section or area. If you have set a query for the repetition area, it is displayed with the corresponding query data label.
You can copy queries which have already been inserted and insert them into another query or section, provided that the set data of both queries is compatible. To do this, select the query you want to copy in the Structure column and press Ctrl+C. Then click in the section or on the query where you want to insert the query and press Ctrl+V.