SQL query in the project title, header or footer

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.


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