Omer-Pitou
asked on
Jasper Report: Crosstab Report- Include Page Footer
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>
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"
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<style name="style_p1" forecolor="#F21511" pattern="" fontSize="8">
<conditionalStyle>
<conditionExpression><![CD
<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
<defaultValueExpression><!
</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
</parameter>
<parameter name="zcentre" class="java.lang.String" isForPrompting="false">
<parameterDescription><![C
</parameter>
<parameter name="zcycle" class="java.lang.String" isForPrompting="false">
<parameterDescription><![C
</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
AND temp_epoints.`companyID` = $P{zcompanyID}
AND temp_ecompanies.`companyID
</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
<field name="Periode2" class="java.math.BigDecima
<field name="Comp1" class="java.math.BigDecima
<field name="TotSem1" class="java.math.BigDecima
<field name="Periode3" class="java.math.BigDecima
<field name="Periode4" class="java.math.BigDecima
<field name="Comp2" class="java.math.BigDecima
<field name="TotSem2" class="java.math.BigDecima
<field name="Periode5" class="java.math.BigDecima
<field name="Periode6" class="java.math.BigDecima
<field name="Comp3" class="java.math.BigDecima
<field name="TotSem3" class="java.math.BigDecima
<field name="TotGen" class="java.math.BigDecima
<field name="Pourcent" class="java.math.BigDecima
<field name="PourcRep" class="java.math.BigDecima
<field name="Cote" class="java.math.BigDecima
<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
</variable>
<group name="Group1">
<groupExpression><![CDATA[
</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
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<imageExpression><![CDATA[
</image>
<frame>
<reportElement x="380" y="0" width="418" height="90" uuid="3ad97b44-2668-4742-a
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<staticText>
<reportElement x="0" y="0" width="418" height="20" forecolor="#0000FF" backcolor="#FFFFFF" uuid="88eaff84-5591-414f-8
<property name="com.jaspersoft.studi
</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
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</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
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
</textField>
<staticText>
<reportElement x="0" y="45" width="75" height="20" uuid="0ef49f52-6f79-446c-a
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Centre:]]><
</staticText>
<textField>
<reportElement x="80" y="45" width="105" height="20" uuid="5f98b91a-fce4-4dee-8
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
</textField>
<staticText>
<reportElement x="0" y="65" width="75" height="20" uuid="d2127d35-fede-4c2f-9
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Cycle:]]></
</staticText>
<textField>
<reportElement x="80" y="65" width="105" height="20" uuid="2ccbf4eb-14d5-4803-9
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
</textField>
<staticText>
<reportElement x="190" y="25" width="75" height="20" uuid="3bd667a0-1a44-4021-b
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Classe:]]><
</staticText>
<staticText>
<reportElement x="190" y="45" width="75" height="20" uuid="519ccb44-feb8-4ea3-9
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9"/>
</textElement>
<text><![CDATA[Période:]]>
</staticText>
<textField>
<reportElement x="270" y="25" width="105" height="20" uuid="21c4adf8-0a9d-4b0a-a
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
</textField>
<textField>
<reportElement x="270" y="45" width="105" height="20" uuid="e54c08a2-39ab-42a5-8
<property name="com.jaspersoft.studi
</reportElement>
<textElement>
<font size="9" isBold="true"/>
</textElement>
<textFieldExpression><![CD
</textField>
</frame>
</band>
</pageHeader>
<pageFooter>
<band height="35">
<property name="com.jaspersoft.studi
<frame>
<reportElement key="" x="0" y="0" width="802" height="35" uuid="1a5c4351-2618-42af-a
<property name="com.jaspersoft.studi
</reportElement>
<textField>
<reportElement x="696" y="8" width="50" height="20" uuid="01f30d25-5c64-4324-9
<textElement textAlignment="Right" verticalAlignment="Middle"
<font size="8"/>
</textElement>
<textFieldExpression><![CD
</textField>
<textField evaluationTime="Report">
<reportElement x="746" y="8" width="40" height="20" uuid="352ea5e9-d50a-4e8a-8
<property name="com.jaspersoft.studi
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle"
<font size="8"/>
</textElement>
<textFieldExpression><![CD
</textField>
<line>
<reportElement x="0" y="8" width="791" height="1" uuid="8368f64d-5e95-4243-a
<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
<property name="com.jaspersoft.studi
<property name="com.jaspersoft.studi
</reportElement>
<textElement verticalAlignment="Middle"
<font size="8"/>
</textElement>
<textFieldExpression><![CD
</textField>
<textField pattern="">
<reportElement x="106" y="8" width="100" height="20" uuid="e11e6930-6997-43d8-9
<textElement verticalAlignment="Middle"
<font size="8"/>
</textElement>
<textFieldExpression><![CD
</textField>
</frame>
</band>
</pageFooter>
<summary>
<band height="215">
<property name="com.jaspersoft.studi
<crosstab>
<reportElement x="0" y="0" width="802" height="215" uuid="c0d83e63-7dbb-45df-b
<property name="com.jaspersoft.studi
</reportElement>
<rowGroup name="Noms" width="175" totalPosition="End">
<bucket class="java.lang.String">
<bucketExpression><![CDATA
</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
<textElement verticalAlignment="Middle"
<font size="8" isBold="false"/>
</textElement>
<textFieldExpression><![CD
</textField>
</cellContents>
</crosstabRowHeader>
<crosstabTotalRowHeader>
<cellContents mode="Opaque" style="Crosstab 1_CT">
<property name="com.jaspersoft.studi
</cellContents>
</crosstabTotalRowHeader>
</rowGroup>
<columnGroup name="CodeCours" height="100" totalPosition="End" headerPosition="Center">
<bucket class="java.lang.String">
<bucketExpression><![CDATA
</bucket>
<crosstabColumnHeader>
<cellContents mode="Opaque" style="Crosstab 1_CH">
<property name="com.jaspersoft.studi
<textField isStretchWithOverflow="tru
<reportElement stretchType="ContainerHeig
<textElement textAlignment="Center" verticalAlignment="Middle"
<font size="8"/>
</textElement>
<textFieldExpression><![CD
</textField>
</cellContents>
</crosstabColumnHeader>
<crosstabTotalColumnHeader
<cellContents mode="Opaque" style="Crosstab 1_CT">
<property name="com.jaspersoft.studi
<staticText>
<reportElement x="0" y="0" width="45" height="100" forecolor="#000000" uuid="0fb81327-6b99-4ba4-b
<textElement textAlignment="Center" verticalAlignment="Middle"
<font size="8" isBold="true"/>
</textElement>
<text><![CDATA[Total]]></t
</staticText>
</cellContents>
</crosstabTotalColumnHeade
</columnGroup>
<measure name="Periode1_MEASURE" class="java.math.BigDecima
<measureExpression><![CDAT
</measure>
<crosstabCell width="35" height="20">
<cellContents mode="Opaque" style="Crosstab 1_CD">
<property name="com.jaspersoft.studi
<textField>
<reportElement x="0" y="0" width="35" height="20" uuid="7677a13c-1a9b-4d95-b
<box leftPadding="5" rightPadding="5"/>
<textElement textAlignment="Right" verticalAlignment="Middle"
<font size="8"/>
</textElement>
<textFieldExpression><![CD
</textField>
</cellContents>
</crosstabCell>
<crosstabCell width="45" height="20" columnTotalGroup="CodeCour
<cellContents mode="Opaque" style="Crosstab 1_CT">
<textField>
<reportElement x="0" y="0" width="45" height="20" forecolor="#000000" uuid="f4e8413c-d7fb-4d7a-8
<box leftPadding="5" rightPadding="5"/>
<textElement textAlignment="Right" verticalAlignment="Middle"
<font size="8"/>
</textElement>
<textFieldExpression><![CD
</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
<cellContents mode="Opaque" style="Crosstab 1_CT"/>
</crosstabCell>
</crosstab>
</band>
</summary>
</jasperReport>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER