结构清晰的crosstab例子.jrxml

报表,关于ireport报表的一些源码(转)

<crosstab >
	<reportElement
		x="50"
		y="10"
		width="507"
		height="72"
		key="crosstab-1"/>
	<crosstabHeaderCell>						
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabHeaderCell>
	
	<rowGroup name="PAGE_NUMBER" width="100" totalPosition="End">
		<bucket>
			<bucketExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></bucketExpression>
		</bucket>
		<crosstabRowHeader>
			<cellContents mode="Transparent">
				<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
			</cellContents>
		</crosstabRowHeader>
		
		<crosstabTotalRowHeader>		
			<cellContents mode="Transparent">
				<box topBorder="None" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
			</cellContents>
		</crosstabTotalRowHeader>
	</rowGroup>
	
	<rowGroup name="COLUMN_NUMBER" width="100" totalPosition="End">
		<bucket>
			<bucketExpression class="java.lang.Integer"><![CDATA[$V{COLUMN_NUMBER}]]></bucketExpression>
		</bucket>
		<crosstabRowHeader>
			<cellContents mode="Transparent">
				<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
			</cellContents>
		</crosstabRowHeader>
		
		<crosstabTotalRowHeader>
			<cellContents mode="Transparent">
				<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
			</cellContents>
		</crosstabTotalRowHeader>
	</rowGroup>
	
	
	<columnGroup name="REPORT_COUNT" height="25" headerPosition="Center">
		<bucket>
			<bucketExpression class="java.lang.Integer"><![CDATA[$V{REPORT_COUNT}]]></bucketExpression>
		</bucket>
		<crosstabColumnHeader>
			<cellContents mode="Transparent">
				<box topBorder="1Point" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
			</cellContents>
		</crosstabColumnHeader>
			<crosstabTotalColumnHeader>
				<cellContents mode="Transparent">
					<box topBorder="1Point" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
				</cellContents>
			</crosstabTotalColumnHeader>
	</columnGroup>
	
	<columnGroup name="REPORT_CONNECTION" height="25" headerPosition="Center">
		<bucket>
			<bucketExpression class="java.sql.Connection"><![CDATA[$P{REPORT_CONNECTION}]]></bucketExpression>
		</bucket>
		<crosstabColumnHeader>
			<cellContents mode="Transparent">
				<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
			</cellContents>
		</crosstabColumnHeader>
		
		<crosstabTotalColumnHeader>
			<cellContents mode="Transparent">
				<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
			</cellContents>
		</crosstabTotalColumnHeader>
	</columnGroup>

	<measure name="PAGE_NUMBER_Count" class="java.lang.Integer" calculation="Count">
		<measureExpression><![CDATA[$V{PAGE_NUMBER}]]></measureExpression>
	</measure>
	
	<crosstabCell width="90" height="30">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
		
	<crosstabCell width="103" height="30" columnTotalGroup="REPORT_CONNECTION">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<crosstabCell width="134" height="30" columnTotalGroup="REPORT_COUNT">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<crosstabCell width="90" height="30" rowTotalGroup="COLUMN_NUMBER">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<crosstabCell width="103" height="30" rowTotalGroup="COLUMN_NUMBER" columnTotalGroup="REPORT_CONNECTION">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<crosstabCell width="134" height="30" rowTotalGroup="COLUMN_NUMBER" columnTotalGroup="REPORT_COUNT">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<crosstabCell width="90" height="30" rowTotalGroup="PAGE_NUMBER">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<crosstabCell width="103" height="30" rowTotalGroup="PAGE_NUMBER" columnTotalGroup="REPORT_CONNECTION">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<crosstabCell width="134" height="30" rowTotalGroup="PAGE_NUMBER" columnTotalGroup="REPORT_COUNT">
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</crosstabCell>
	
	<whenNoDataCell>					
		<cellContents mode="Transparent">
			<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/>
		</cellContents>
	</whenNoDataCell>
	
</crosstab>