reportdef/report/frame/bands/band/cell

Description

A required element that is layout and contents of a single cell within a band.

Diagram

media/image49.jpeg

Attributes

alignment, chart-attr-name, data-format, decimal-places, indent-level, name, style, suppress-formatting, suppress-zeroes, type

Example

In a table frame, a single table-body band can produce a nearly unlimited number of rows. The data will fill in as many rows as were returned by the source query. A table-column-header band will place a single row of cells above the body of a report, and is used to provide column names. The table-group-header places a single row above each set of body data each time the data is broken into its respective group (as defined by the group-item in <groups>.)

<queries>
	<query datasource="" name="Query0" result-type="multiple-rows" type="iquery">
		<subjectArea name="Tender Fixed Period Total">
			<columns>
				<column name="rvc" />
				<column name="busHour" />
				<column name="tndrName" />
				<column name="tndrCnt" aggregate="sum" />
				<column name="tndrTtl" aggregate="sum" />
			</columns>
			<orders>
				<order name="busHour" direction="ASC" />
				<order name="tndrName" direction="ASC" />
			</orders>
		</subjectArea>
	</query>
</queries>
<parameters>
...
</parameters>

<report>
	<frame type="table" name="Tender Media by Revenue Center" query-name="Query0">
		<groups>
			<group name="Total">
				<group-item name="organizationId" data-type="integer" />
				<group-expr name="AllTndrCnt" type="sum" column="tndrCnt" />
				<group-expr name="AllTndrTtl" type="sum" column="tndrTtl" />
				<group-calc name="AllPrctTndrTtl" data-type="percent">1</group-calc>
			</group>
			<group name="RvcAggregates">
				<group-item name="rvc" data-type="text" />
				<group-expr name="RvcTndrCnt" type="sum" column="tndrCnt" />
				<group-expr name="RvcTndrTtl" type="sum" column="tndrTtl" />
				<group-calc name="RvcPrctTndrTtl" data-type="percent">RvcTndrTtl / AllTndrTtl</group-calc>
			</group>
		</groups>
		<bands>
			<band type="table-column-header">
				<cell type="text" print-width="68" alignment="left" data-format="text">Name</cell>
				<cell type="text" print-width="68" alignment="right" data-format="text">Tender Count</cell>
				<cell type="text" print-width="68" alignment="right" data-format="text">Tender Amount</cell>
				<cell type="text" print-width="68" alignment="right" data-format="text">Percent of Total Tender Amount</cell>
			</band>
			<band type="table-group-header" group-name="Total">
				<cell type="text" print-width="68" alignment="left" data-format="text">TOTAL</cell>
				<cell type="column" print-width="68" alignment="right" data-format="integer">AllTndrCnt</cell>
				<cell type="column" print-width="68" alignment="right" data-format="currency">AllTndrTtl</cell>
				<cell type="column" print-width="68" alignment="right" data-format="percent">AllPrctTndrTtl</cell>
			</band>
			<band type="table-group-header" group-name="RvcAggregates">
				<cell type="column" print-width="68" alignment="left" data-format="text">rvc</cell>
				<cell type="column" print-width="68" alignment="right" data-format="integer">RvcTndrCnt</cell>
				<cell type="column" print-width="68" alignment="right" data-format="currency">RvcTndrTtl</cell>
				<cell type="column" print-width="68" alignment="right" data-format="percent">RvcPrctTndrTtl</cell>
			</band>
			<band type="table-body">
				<cell type="column" print-width="68" alignment="left" data-format="text">tndrName</cell>
				<cell type="column" print-width="68" alignment="right" data-format="integer">tndrCnt</cell>
				<cell type="column" print-width="68" alignment="right" data-format="currency">tndrTtl</cell>
				<cell type="expr" print-width="68" alignment="right" data-format="percent" name="TotalPercentage">tndrTtl / AllTndrTtl</cell>
			</band>
		</bands>
	</frame>
	...
</report>