Dear Sirs
Below is the crosstab report, and I would like to have the page footer forced at bottom. The difficulty I have is that I can only put the cross tab object in the Summary Section. I even tried to create a dummy group so that I can put the cross tab object in the dummy group footer and leave my footer in the page footer, but this wasn't successful as cross tab seems to only work when placed in summary section.
How can I achieve this.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 6.3.0 -->
<!-- 2016-08-20T15:54:35 -->
<jasperReport xmlns="
http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="school_grillepoints"
pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ef105187-564b-40f9-a
cc7-581359
2c5b30">
<property name="com.jaspersoft.studi
o.data.sql
.tables" value=""/>
<property name="com.jaspersoft.studi
o.unit." value="pixel"/>
<property name="com.jaspersoft.studi
o.data.def
aultdataad
apter" value="FingerSchoolDataAda
pter"/>
<property name="com.jaspersoft.studi
o.unit.pag
eHeight" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.pag
eWidth" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.top
Margin" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.bot
tomMargin"
value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.lef
tMargin" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.rig
htMargin" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.col
umnWidth" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.col
umnSpacing
" value="pixel"/>
<style name="style_p1" forecolor="#F21511" pattern="" fontSize="8">
<conditionalStyle>
<conditionExpression><![CD
ATA[$F{Per
iode1}.com
pareTo(new
BigDecimal($F{MaxPeriode1}
/2)) == -1]]></conditionExpression
>
<style/>
</conditionalStyle>
</style>
<style name="Crosstab_CH" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Crosstab_CG" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Crosstab 1_CH" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Crosstab 1_CG" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Crosstab 1_CT" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Crosstab 1_CD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<parameter name="zcompanyID" class="java.lang.Integer">
<parameterDescription><![C
DATA[]></p
arameterDe
scription>
<defaultValueExpression><!
[CDATA[100
]]></defau
ltValueExp
ression>
</parameter>
<parameter name="zuserreport" class="java.lang.String"/>
<parameter name="ztexte" class="java.lang.String" isForPrompting="false"/>
<parameter name="zannee" class="java.lang.String" isForPrompting="false">
<parameterDescription><![C
DATA[]></p
arameterDe
scription>
</parameter>
<parameter name="zcentre" class="java.lang.String" isForPrompting="false">
<parameterDescription><![C
DATA[]></p
arameterDe
scription>
</parameter>
<parameter name="zcycle" class="java.lang.String" isForPrompting="false">
<parameterDescription><![C
DATA[]></p
arameterDe
scription>
</parameter>
<parameter name="zclasse" class="java.lang.String" isForPrompting="false"/>
<parameter name="zperiode" class="java.lang.String" isForPrompting="false"/>
<queryString>
<![CDATA[SELECT *
FROM temp_epoints,
temp_ecompanies
WHERE
temp_epoints.`userReport` = $P{zuserreport}
AND temp_ecompanies.`userRepor
t` = $P{zuserreport}
AND temp_epoints.`companyID` = $P{zcompanyID}
AND temp_ecompanies.`companyID
` = $P{zcompanyID}]]>
</queryString>
<field name="UserReport" class="java.lang.String"/>
<field name="CompanyID" class="java.lang.Integer"/
>
<field name="Annee" class="java.lang.String"/>
<field name="Cycle" class="java.lang.String"/>
<field name="CodeClasse" class="java.lang.String"/>
<field name="CodeEleve" class="java.lang.String"/>
<field name="Noms" class="java.lang.String"/>
<field name="CodeCours" class="java.lang.String"/>
<field name="MaxPeriode1" class="java.lang.Integer"/
>
<field name="MaxPeriode2" class="java.lang.Integer"/
>
<field name="MaxComp1" class="java.lang.Integer"/
>
<field name="MaxSemestre1" class="java.lang.Integer"/
>
<field name="MaxPeriode3" class="java.lang.Integer"/
>
<field name="MaxPeriode4" class="java.lang.Integer"/
>
<field name="MaxComp2" class="java.lang.Integer"/
>
<field name="MaxSemestre2" class="java.lang.Integer"/
>
<field name="MaxPeriode5" class="java.lang.Integer"/
>
<field name="MaxPeriode6" class="java.lang.Integer"/
>
<field name="MaxComp3" class="java.lang.Integer"/
>
<field name="MaxSemestre3" class="java.lang.Integer"/
>
<field name="MaxTotGen" class="java.lang.Integer"/
>
<field name="Periode1" class="java.math.BigDecima
l"/>
<field name="Periode2" class="java.math.BigDecima
l"/>
<field name="Comp1" class="java.math.BigDecima
l"/>
<field name="TotSem1" class="java.math.BigDecima
l"/>
<field name="Periode3" class="java.math.BigDecima
l"/>
<field name="Periode4" class="java.math.BigDecima
l"/>
<field name="Comp2" class="java.math.BigDecima
l"/>
<field name="TotSem2" class="java.math.BigDecima
l"/>
<field name="Periode5" class="java.math.BigDecima
l"/>
<field name="Periode6" class="java.math.BigDecima
l"/>
<field name="Comp3" class="java.math.BigDecima
l"/>
<field name="TotSem3" class="java.math.BigDecima
l"/>
<field name="TotGen" class="java.math.BigDecima
l"/>
<field name="Pourcent" class="java.math.BigDecima
l"/>
<field name="PourcRep" class="java.math.BigDecima
l"/>
<field name="Cote" class="java.math.BigDecima
l"/>
<field name="Maxima" class="java.lang.Integer"/
>
<field name="COLUMN_39" class="java.lang.String"/>
<field name="COLUMN_40" class="java.lang.Integer"/
>
<field name="Sigle" class="java.lang.String"/>
<field name="COLUMN_42" class="java.lang.String"/>
<field name="Telephone" class="java.lang.String"/>
<field name="Fax" class="java.lang.String"/>
<field name="Email" class="java.lang.String"/>
<field name="Site" class="java.lang.String"/>
<field name="DocAdmin" class="java.lang.String"/>
<field name="Siege" class="java.lang.String"/>
<field name="InfoBancaire" class="java.lang.String"/>
<field name="Sceau" class="java.io.InputStream
"/>
<field name="Logo" class="java.io.InputStream
"/>
<field name="Actif" class="java.lang.Boolean"/
>
<sortField name="Noms"/>
<sortField name="CodeCours"/>
<variable name="vnum" class="java.lang.Integer" calculation="Count">
<variableExpression><![CDA
TA[1]]></v
ariableExp
ression>
</variable>
<group name="Group1">
<groupExpression><![CDATA[
$F{Company
ID}]]></gr
oupExpress
ion>
</group>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="96">
<image>
<reportElement positionType="Float" x="0" y="0" width="175" height="75" uuid="ba7adef1-9c39-4ea3-9
4c9-d660e4
bbd52f">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.y" value="pixel"/>
</reportElement>
<imageExpression><![CDATA[
$F{Logo}]]
></imageEx
pression>
</image>
<frame>
<reportElement x="380" y="0" width="418" height="90" uuid="3ad97b44-2668-4742-a
e8e-73b415
5a361d">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.x" value="pixel"/>
</reportElement>
<staticText>
<reportElement x="0" y="0" width="418" height="20" forecolor="#0000FF" backcolor="#FFFFFF" uuid="88eaff84-5591-414f-8
788-950ec0
a8c1c9">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
</reportElement>
<box rightPadding="0">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#0000FF"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#0000FF"/>
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#0000FF"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#0000FF"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"
>
<font size="12" isBold="true" isUnderline="false"/>
</textElement>
<text><![CDATA[GRILLE DES POINTS]]></text>
</staticText>
<staticText>
<reportElement x="0" y="25" width="75" height="20" uuid="580bc15d-7b18-478e-b
267-390ee9
c783c6">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.y" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Année Scolaire:]]></text>
</staticText>
<textField>
<reportElement x="80" y="25" width="105" height="20" uuid="4e776fcd-9693-4f90-9
7e0-b2e9d1
6d2859">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.x" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.y" value="pixel"/>
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
ATA[$P{zan
nee}]]></t
extFieldEx
pression>
</textField>
<staticText>
<reportElement x="0" y="45" width="75" height="20" uuid="0ef49f52-6f79-446c-a
6ff-b248a7
9cc65d">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.x" value="pixel"/>
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Centre:]]><
/text>
</staticText>
<textField>
<reportElement x="80" y="45" width="105" height="20" uuid="5f98b91a-fce4-4dee-8
1c8-fd1e58
5edd6b">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
ATA[$P{zce
ntre}]]></
textFieldE
xpression>
</textField>
<staticText>
<reportElement x="0" y="65" width="75" height="20" uuid="d2127d35-fede-4c2f-9
663-42c623
0b26f7">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Cycle:]]></
text>
</staticText>
<textField>
<reportElement x="80" y="65" width="105" height="20" uuid="2ccbf4eb-14d5-4803-9
191-6ffa4c
72fd67">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.x" value="pixel"/>
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
ATA[$P{zcy
cle}]]></t
extFieldEx
pression>
</textField>
<staticText>
<reportElement x="190" y="25" width="75" height="20" uuid="3bd667a0-1a44-4021-b
119-db8925
3cdc19">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Classe:]]><
/text>
</staticText>
<staticText>
<reportElement x="190" y="45" width="75" height="20" uuid="519ccb44-feb8-4ea3-9
444-6fe1b4
60564b">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.x" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.y" value="pixel"/>
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Période:]]>
</text>
</staticText>
<textField>
<reportElement x="270" y="25" width="105" height="20" uuid="21c4adf8-0a9d-4b0a-a
319-af3a20
774a4a">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.x" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.y" value="pixel"/>
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
ATA[$P{zcl
asse}]]></
textFieldE
xpression>
</textField>
<textField>
<reportElement x="270" y="45" width="105" height="20" uuid="e54c08a2-39ab-42a5-8
e8b-642a85
9e47fb">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
ATA[$P{zpe
riode}]]><
/textField
Expression
>
</textField>
</frame>
</band>
</pageHeader>
<pageFooter>
<band height="35">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<frame>
<reportElement key="" x="0" y="0" width="802" height="35" uuid="1a5c4351-2618-42af-a
a92-7b7104
9faeb9">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
</reportElement>
<textField>
<reportElement x="696" y="8" width="50" height="20" uuid="01f30d25-5c64-4324-9
ccf-912c23
4d4a53"/>
<textElement textAlignment="Right" verticalAlignment="Middle"
>
<font size="8"/>
</textElement>
<textFieldExpression><![CD
ATA["Page " + $V{PAGE_NUMBER}]]></textFi
eldExpress
ion>
</textField>
<textField evaluationTime="Report">
<reportElement x="746" y="8" width="40" height="20" uuid="352ea5e9-d50a-4e8a-8
58a-632d32
caa845">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle"
>
<font size="8"/>
</textElement>
<textFieldExpression><![CD
ATA[" / " + $V{PAGE_NUMBER}]]></textFi
eldExpress
ion>
</textField>
<line>
<reportElement x="0" y="8" width="791" height="1" uuid="8368f64d-5e95-4243-a
7fd-070719
cd83e5"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<textField pattern="dd/MM/yyyy HH:mm:ss">
<reportElement x="0" y="8" width="100" height="20" uuid="4ec68a2b-d5e2-43d7-8
db4-b27440
75c55f">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<property name="com.jaspersoft.studi
o.unit.x" value="pixel"/>
</reportElement>
<textElement verticalAlignment="Middle"
>
<font size="8"/>
</textElement>
<textFieldExpression><![CD
ATA[new java.util.Date()]]></textF
ieldExpres
sion>
</textField>
<textField pattern="">
<reportElement x="106" y="8" width="100" height="20" uuid="e11e6930-6997-43d8-9
1ec-bc4915
80a69e"/>
<textElement verticalAlignment="Middle"
>
<font size="8"/>
</textElement>
<textFieldExpression><![CD
ATA[$F{Com
panyID}]]>
</textFiel
dExpressio
n>
</textField>
</frame>
</band>
</pageFooter>
<summary>
<band height="215">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<crosstab>
<reportElement x="0" y="0" width="802" height="215" uuid="c0d83e63-7dbb-45df-b
fa1-422de7
4feb60">
<property name="com.jaspersoft.studi
o.layout" value="com.jaspersoft.stud
io.editor.
layout.Ver
ticalRowLa
yout"/>
</reportElement>
<rowGroup name="Noms" width="175" totalPosition="End">
<bucket class="java.lang.String">
<bucketExpression><![CDATA
[$F{Noms}]
]></bucket
Expression
>
</bucket>
<crosstabRowHeader>
<cellContents mode="Opaque" style="Crosstab 1_CH">
<box topPadding="0" leftPadding="5" bottomPadding="0" rightPadding="5"/>
<textField>
<reportElement x="0" y="0" width="165" height="20" uuid="7fc14488-53d0-4980-9
3ac-49a056
4f99ea"/>
<textElement verticalAlignment="Middle"
>
<font size="8" isBold="false"/>
</textElement>
<textFieldExpression><![CD
ATA[$V{ROW
_COUNT} + ". " + $V{Noms}]]></textFieldExpr
ession>
</textField>
</cellContents>
</crosstabRowHeader>
<crosstabTotalRowHeader>
<cellContents mode="Opaque" style="Crosstab 1_CT">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
</cellContents>
</crosstabTotalRowHeader>
</rowGroup>
<columnGroup name="CodeCours" height="100" totalPosition="End" headerPosition="Center">
<bucket class="java.lang.String">
<bucketExpression><![CDATA
[$F{CodeCo
urs}]]></b
ucketExpre
ssion>
</bucket>
<crosstabColumnHeader>
<cellContents mode="Opaque" style="Crosstab 1_CH">
<property name="com.jaspersoft.studi
o.unit.hei
ght" value="pixel"/>
<textField isStretchWithOverflow="tru
e">
<reportElement stretchType="ContainerHeig
ht" x="0" y="0" width="35" height="100" uuid="52f3fae6-a1ef-4a11-a
5c4-1ff506
57084a"/>
<textElement textAlignment="Center" verticalAlignment="Middle"
rotation="Right">
<font size="8"/>
</textElement>
<textFieldExpression><![CD
ATA[$V{Cod
eCours}]]>
</textFiel
dExpressio
n>
</textField>
</cellContents>
</crosstabColumnHeader>
<crosstabTotalColumnHeader
>
<cellContents mode="Opaque" style="Crosstab 1_CT">
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
<staticText>
<reportElement x="0" y="0" width="45" height="100" forecolor="#000000" uuid="0fb81327-6b99-4ba4-b
725-133161
d89984"/>
<textElement textAlignment="Center" verticalAlignment="Middle"
rotation="Right">
<font size="8" isBold="true"/>
</textElement>
<text><![CDATA[Total]]></t
ext>
</staticText>
</cellContents>
</crosstabTotalColumnHeade
r>
</columnGroup>
<measure name="Periode1_MEASURE" class="java.math.BigDecima
l" calculation="Sum">
<measureExpression><![CDAT
A[$F{Perio
de1}]]></m
easureExpr
ession>
</measure>
<crosstabCell width="35" height="20">
<cellContents mode="Opaque" style="Crosstab 1_CD">
<property name="com.jaspersoft.studi
o.unit.wid
th" value="pixel"/>
<textField>
<reportElement x="0" y="0" width="35" height="20" uuid="7677a13c-1a9b-4d95-b
893-4269c5
843461"/>
<box leftPadding="5" rightPadding="5"/>
<textElement textAlignment="Right" verticalAlignment="Middle"
>
<font size="8"/>
</textElement>
<textFieldExpression><![CD
ATA[$V{Per
iode1_MEAS
URE}]]></t
extFieldEx
pression>
</textField>
</cellContents>
</crosstabCell>
<crosstabCell width="45" height="20" columnTotalGroup="CodeCour
s">
<cellContents mode="Opaque" style="Crosstab 1_CT">
<textField>
<reportElement x="0" y="0" width="45" height="20" forecolor="#000000" uuid="f4e8413c-d7fb-4d7a-8
e9b-fc8d69
d835eb"/>
<box leftPadding="5" rightPadding="5"/>
<textElement textAlignment="Right" verticalAlignment="Middle"
>
<font size="8"/>
</textElement>
<textFieldExpression><![CD
ATA[$V{Per
iode1_MEAS
URE}]]></t
extFieldEx
pression>
</textField>
</cellContents>
</crosstabCell>
<crosstabCell width="35" height="0" rowTotalGroup="Noms">
<cellContents mode="Opaque" style="Crosstab 1_CT"/>
</crosstabCell>
<crosstabCell width="45" height="0" rowTotalGroup="Noms" columnTotalGroup="CodeCour
s">
<cellContents mode="Opaque" style="Crosstab 1_CT"/>
</crosstabCell>
</crosstab>
</band>
</summary>
</jasperReport>
To solve the problem I add isUsingCache="true" to the image tag (<image isUsingCache="true">....</