The reporting tool uses substring between {{ and }} as a SQL query text. The query has to return only one scalar value. Also, only one query can be used in each report item.

Example:

Average items per order is {{select avg(Qty) from [Order Details] }}.