reportdef/queries/query/subjectArea/columns/column
Description |
This required element contains the list of columns given in metadata that will be returned in the report. The metadata appears in the Subject Area (Alias) section of the advanced editor of the report builder. The alias name, which appears in the parentheses, must be used for the column. |
Diagram |
|
Attributes |
Example
The example shows return records
from Tender Daily Total
between business dates 2019-11-22
and 2019-11-27
with tndrNum
> 10
and order the returns values
by revenue center.
... <query datasource="" name="Query0" result-type="multiple-rows" type="iquery"> <subjectArea name="Tender Daily Total"> <columns> <column name="rvc" /> <column name="tndrName" /> <column name="tndrCnt" aggregate="sum" /> <column name="tndrTtl" aggregate="sum" /> </columns> <orders> <order name="rvc" direction="ASC" /> </orders> <filters> <filter name="busDate" type="dateRangeFilter"> <start>2019-11-22</start> <end>2019-11-27</end> </filter> <filter name="tndrNum" type="relationalFilter" comparison="GREATER_THAN"> <data>10</data> </filter> </filters> </subjectArea> </query> ...
Parent topic: Elements