reportdef/queries/query/subjectArea/columns

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
Child Elements	column

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>
...