Jump to content
Changes to the Jaspersoft community edition download ×

Totals per group and report


Recommended Posts

By: Ana - ana_abrantes

Totals per group and report

2006-02-16 14:35

I couldn´t find a solution to my problem anywhere, so I'm posting this message.

I have a report that shows orders per client. There's a group for client, a group for order and a subreport for the itens of an order.

In this subreport there's a variable that holds the value (price * quantity) of the item.

What I want is to have a price total per order, another one per client and finally a report total.

I used returnValue of subreport to sum the value to my 3 variables of total, but only the first one is correct, the others take the value of the last item.

Please, how can I do this ?

 

 

 

 

 

By: Lucian Chirita - lucianc

RE: Totals per group and report

2006-02-17 01:49

Could you post your JRXML variable and returnValue definitions?

 

Regards,

Lucian

 

 

 

 

By: CarlosFelippe - cfelippe

RE: Totals per group and report

2006-02-17 09:06

hello Ana... I´m having a problem like that...

 

If someone can help us i'll be very glad.. Any idea on how can we do this Teodor?

 

 

 

 

By: Ana - ana_abrantes

RE: Totals per group and report

2006-02-17 08:18

Here are the definition of the variables for totals from the two groups:

<variable name="total" class="java.lang.Double" resetType="Group" incrementType="Group" incrementGroup="pedido" resetGroup="pedido" calculation="Nothing">

<initialValueExpression><![CDATA[new

Double(0)]]></initialValueExpression>

</variable>

<variable name="totalCliente" class="java.lang.Double" resetType="Group" resetGroup="cliente" calculation="Nothing">

<initialValueExpression><![CDATA[new

Double(0)]]></initialValueExpression>

</variable>

 

The corresponding returnValues:

<returnValue subreportVariable="valor" toVariable="total"/>

<returnValue subreportVariable="valor" toVariable="totalCliente" calculation="Sum"/>

(I´ve already used without the calculation like the first, but it doesn't work either)

 

And here is the variable in the subreport:

<variable name="valor" class="java.lang.Double" resetType="Report" calculation="Sum">

<variableExpression><![CDATA[$F{quantidade}*$F{produto}.getPreco()]]></variableExpression>

<initialValueExpression><![CDATA[new Double(0)]]></initialValueExpression>

</variable>

 

Can you see anything ?

 

Thanks again...

 

 

 

 

By: Lucian Chirita - lucianc

RE: Totals per group and report

2006-02-17 09:25

The culprit is calculation="Nothing". Variables that are used as subreport return values should have calculation="System".

 

Also increment type and group do not make sense for such variables, but don't think they can hurt.

 

HTH,

Lucian

 

 

 

 

By: Ana - ana_abrantes

RE: Totals per group and report

2006-02-17 14:29

Now it works.

I did like you said and put calculation="System" in all variables from my master report.

But I had to put calculation="Sum" in the returnValues of the subReport element.

 

Thanks a lot!!!

 

 

 

 

 

By: CarlosFelippe - cfelippe

RE: Totals per group and report

2006-02-21 10:37

let me post here my problem..

 

i have a masterReport variable that neeeds to show values that comes from the subreport variable...

 

if i use calculation = "System" in the variable="curso" on the master and in the subreport variable my pdf only show the first record that will need to comes...

 

explaining... my masterreport needs to print a value respecting what is in the subreport in the moment of filling the masterReport pageHeader

 

my masterReport code:

<?xml version="1.0" encoding="UTF-8" ?>

<!-- Created with iReport - A designer for JasperReports -->

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="historico"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="548"

columnSpacing="0"

leftMargin="17"

rightMargin="17"

topMargin="17"

bottomMargin="17"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false"

whenResourceMissingType="Empty">

<property name="ireport.scriptlethandling" value="0" />

<property name="ireport.encoding" value="UTF-8" />

<import value="java.util.*" />

<import value="net.sf.jasperreports.engine.*" />

<import value="net.sf.jasperreports.engine.data.*" />

<reportFont name="0" isDefault="true" fontName="Luxi Sans" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1250" isPdfEmbedded="false"/>

<parameter name="pathSubRelSegmentos" isForPrompting="false" class="java.lang.String"/>

<parameter name="pathSubRelTeses" isForPrompting="false" class="java.lang.String"/>

<parameter name="registro" isForPrompting="false" class="java.lang.String"/>

<parameter name="identidade" isForPrompting="false" class="java.lang.String"/>

<parameter name="nome" isForPrompting="false" class="java.lang.String"/>

<parameter name="certificadoMilitarDispensa" isForPrompting="false" class="java.lang.String"/>

<parameter name="cpf" isForPrompting="false" class="java.lang.String"/>

<parameter name="dataNascimento" isForPrompting="false" class="java.lang.String"/>

<parameter name="naturalidade" isForPrompting="false" class="java.lang.String"/>

<parameter name="nacionalidade" isForPrompting="false" class="java.lang.String"/>

<parameter name="tituloEleitoral" isForPrompting="false" class="java.lang.String"/>

<parameter name="observacao" isForPrompting="false" class="java.lang.String"/>

<parameter name="segmentacaoSituacaoMatricula" isForPrompting="false" class="java.lang.String"/>

<parameter name="situacaoMatricula" isForPrompting="false" class="java.lang.String"/>

<parameter name="situacaoMatriculaCodigo" isForPrompting="false" class="java.lang.String"/>

<field name="listaTeses" class="java.lang.Object"/>

<field name="listaSegmentos" class="java.lang.Object"/>

<field name="segmentacaoIngresso" class="java.lang.String"/>

<field name="tamanhoListaTeses" class="java.lang.Integer"/>

<variable name="REGISTROS_POR_PAGINA" class="java.lang.Integer" resetType="Group" incrementType="Page" resetGroup="grupoTese" calculation="Nothing">

<variableExpression><![CDATA[new Integer($V{REGISTROS_POR_PAGINA}.intValue() + 1)]]></variableExpression>

<initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression>

</variable>

<variable name="REGISTROS_POR_PERIODO" class="java.lang.Integer" resetType="Group" incrementType="Page" resetGroup="grupoPeriodo" calculation="Nothing">

<variableExpression><![CDATA[new Integer($V{REGISTROS_POR_PERIODO}.intValue() + 1)]]></variableExpression>

<initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression>

</variable>

<variable name="IMPRIMIU_INGRESSO" class="java.lang.Boolean" resetType="Report" incrementType="Page" calculation="Nothing">

<variableExpression><![CDATA[new Boolean(false)]]></variableExpression>

<initialValueExpression><![CDATA[new Boolean(true)]]></initialValueExpression>

</variable>

<variable name="periodo" class="java.lang.String" resetType="Report" incrementType="Page" calculation="Nothing">

<variableExpression><![CDATA[ ]]></variableExpression>

</variable>

<variable name="IMPRIMIU_OBSERVACAO" class="java.lang.Boolean" resetType="Report" incrementType="Group" incrementGroup="grupoObservacao" calculation="Nothing">

<variableExpression><![CDATA[new Boolean(false)]]></variableExpression>

<initialValueExpression><![CDATA[new Boolean(true)]]></initialValueExpression>

</variable>

<variable name="areaConhecimento" class="java.lang.String" resetType="Report" calculation="Nothing">

</variable>

<variable name="dataInicioCurso" class="java.lang.String" resetType="Report" calculation="Nothing">

</variable>

<variable name="dataFimCurso" class="java.lang.String" resetType="Report" calculation="Nothing">

</variable>

<variable name="descricaoTipoNivel" class="java.lang.String" resetType="Report" calculation="Nothing">

</variable>

<variable name="centro" class="java.lang.String" resetType="Report" calculation="Nothing">

</variable>

<variable name="unidade" class="java.lang.String" resetType="Report" calculation="Nothing">

</variable>

<variable name="curso" class="java.lang.String" resetType="Report" incrementType="Page" calculation="System">

<variableExpression><![CDATA[$V{curso}]]></variableExpression>

<initialValueExpression><![CDATA[$V{curso}]]></initialValueExpression>

</variable>

<variable name="reconhecimento" class="java.lang.String" resetType="Report" calculation="Nothing">

</variable>

<variable name="matriculaSIAPECoordenador" class="java.lang.String" resetType="Report" incrementType="Page" calculation="Nothing">

</variable>

<variable name="nomeCoordenadorCurso" class="java.lang.String" resetType="Report" incrementType="Page" calculation="Nothing">

</variable>

<group name="grupoCurso" isStartNewColumn="false" isStartNewPage="true" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[$V{curso}]]></groupExpression>

<groupHeader>

<band height="0" isSplitAllowed="true" >

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

</band>

</groupFooter>

</group>

<group name="grupoTese" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[null]]></groupExpression>

<groupHeader>

<band height="0" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>

</band>

</groupHeader>

<groupFooter>

<band height="22" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(!$F{tamanhoListaTeses}.equals(new Integer(0)))]]></printWhenExpression>

<subreport isUsingCache="true">

<reportElement

mode="Transparent"

x="48"

y="10"

width="430"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

key="subreport-1"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<subreportParameter name="listaTeses">

<subreportParameterExpression><![CDATA[$F{listaTeses}]]></subreportParameterExpression>

</subreportParameter>

<dataSourceExpression><![CDATA[$F{listaTeses}]]></dataSourceExpression>

<subreportExpression class="java.lang.String"><![CDATA[$P{pathSubRelTeses}]]></subreportExpression>

</subreport>

<staticText>

<reportElement

mode="Opaque"

x="51"

y="0"

width="421"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-57"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Teses]]></text>

</staticText>

</band>

</groupFooter>

</group>

<group name="groupSituacaoMatricula" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[$P{situacaoMatricula}]]></groupExpression>

<groupHeader>

<band height="0" isSplitAllowed="true" >

</band>

</groupHeader>

<groupFooter>

<band height="20" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean (! ($P{situacaoMatriculaCodigo}.startsWith("A")))]]></printWhenExpression>

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

mode="Transparent"

x="54"

y="0"

width="418"

height="19"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-60"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="true"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica-BoldOblique" size="7" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Matrícula "+ $P{situacaoMatricula}+ " em "+ $P{segmentacaoSituacaoMatricula}]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="0"

y="19"

width="473"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="line-5"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

printWhenGroupChanges="grupoPeriodo"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

</band>

</groupFooter>

</group>

<group name="grupoObservacao" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[$P{observacao}]]></groupExpression>

<groupHeader>

<band height="0" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="0"

y="-1"

width="473"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="line-2"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

printWhenGroupChanges="grupoPeriodo"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

</band>

</groupHeader>

<groupFooter>

<band height="30" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(($P{observacao}!=null) && (!$P{observacao}.equals("")))]]></printWhenExpression>

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

mode="Transparent"

x="54"

y="0"

width="418"

height="28"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-52"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="true"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica-Bold" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$P{observacao}]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="0"

y="29"

width="473"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="line-4"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

printWhenGroupChanges="grupoPeriodo"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

</band>

</groupFooter>

</group>

<group name="grupoPeriodo" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[$V{periodo}]]></groupExpression>

<groupHeader>

<band height="0" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>

</band>

</groupFooter>

</group>

<group name="grupoIngresso" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[null]]></groupExpression>

<groupHeader>

<band height="27" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

mode="Transparent"

x="102"

y="3"

width="371"

height="23"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-47"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica-Bold" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Matrícula por admissão em " + $F{segmentacaoIngresso}]]></textFieldExpression>

</textField>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>

</band>

</groupFooter>

</group>

<group name="grupoTitulo" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

<groupExpression><![CDATA[null]]></groupExpression>

<groupHeader>

<band height="9" isSplitAllowed="false" >

<printWhenExpression><![CDATA[new Boolean($V{REGISTROS_POR_PAGINA}.intValue() == 0 )]]></printWhenExpression>

<staticText>

<reportElement

mode="Opaque"

x="0"

y="0"

width="51"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-46"

stretchType="RelativeToTallestObject"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Período]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="51"

y="0"

width="51"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-47"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Código]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="102"

y="0"

width="192"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-48"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Nome da Disciplina/RCC]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="324"

y="0"

width="29"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-49"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[CH]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="445"

y="0"

width="27"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-50"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[sF]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="350"

y="0"

width="35"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-51"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Grau]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="294"

y="0"

width="31"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-52"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[CrR]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="384"

y="0"

width="30"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-53"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[CrO]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="414"

y="0"

width="31"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-54"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Pontos]]></text>

</staticText>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

<printWhenExpression><![CDATA[new Boolean(false)]]></printWhenExpression>

</band>

</groupFooter>

</group>

<background>

<band height="808" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="0"

y="140"

width="51"

height="668"

forecolor="#000000"

backcolor="#D2D2D2"

key="rectangle-2"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</rectangle>

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="50"

y="140"

width="425"

height="668"

forecolor="#000000"

backcolor="#FFFFFF"

key="rectangle-3"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</rectangle>

<staticText>

<reportElement

mode="Opaque"

x="473"

y="149"

width="88"

height="54"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-25"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="5" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000" bottomPadding="1"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="1_1_2">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="7" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[A - 3

B - 2

C - 1

D - 0

I - Incompleto]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="473"

y="203"

width="88"

height="127"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-26"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" topPadding="3" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000" bottomPadding="3"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="Left" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="7" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[DECLARAÇÃO

 

Declaro que o curso obedeceu a todas as disposições da Res. CEPG 05/2001 e da Res. CNE/CES nº 1/2001.]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="473"

y="477"

width="88"

height="331"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000" bottomPadding="4"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="Left" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[ ]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="473"

y="330"

width="88"

height="147"

forecolor="#969696"

backcolor="#FFFFFF"

key="staticText"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center" verticalAlignment="Middle" rotation="Left" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[sELO]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="473"

y="141"

width="88"

height="9"

forecolor="#000000"

backcolor="#D2D2D2"

key="staticText-55"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[CONCEITOS]]></text>

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

mode="Opaque"

x="541"

y="515"

width="15"

height="281"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-55"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" topPadding="5" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center" verticalAlignment="Top" rotation="Left" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="9" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Coordenador do Curso"]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="grupoPeriodo" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

mode="Opaque"

x="531"

y="517"

width="11"

height="278"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-56"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" topPadding="5" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center" verticalAlignment="Top" rotation="Left" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica-Bold" size="6" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Nome: "+$V{nomeCoordenadorCurso} +" - " + "Siape: " +$V{matriculaSIAPECoordenador}]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="527"

y="516"

width="0"

height="280"

forecolor="#000000"

backcolor="#FFFFFF"

key="line-3"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

<staticText>

<reportElement

mode="Opaque"

x="482"

y="515"

width="23"

height="282"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-58"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="Left" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="9" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Este documento só é válido com o selo da UFRJ e com a assinatura do responsável pelo curso.]]></text>

</staticText>

</band>

</background>

<title>

<band height="0" isSplitAllowed="true" >

</band>

</title>

<pageHeader>

<band height="141" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="0"

y="0"

width="561"

height="141"

forecolor="#000000"

backcolor="#FFFFFF"

key="rectangle-1"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</rectangle>

<image scaleImage="RetainShape" vAlign="Top" hAlign="Left" isUsingCache="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

mode="Opaque"

x="1"

y="3"

width="67"

height="78"

forecolor="#000000"

backcolor="#FFFFFF"

key="image-1"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<graphicElement stretchType="NoStretch" pen="None" fill="Solid" />

<imageExpression class="java.lang.String"><![CDATA["/home/chronos/cfc/workspace/dev/jrxmls/historico/minerva.jpg"]]></imageExpression>

</image>

<staticText>

<reportElement

mode="Opaque"

x="71"

y="13"

width="189"

height="16"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-1"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="7" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Av. Brigadeiro Trompowsky s/n - CEP 21941-590

Cidade Universitária - Ilha do Fundão]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="71"

y="41"

width="189"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-2"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[PR-2/SRA]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="71"

y="53"

width="189"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-3"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica-Bold" size="15" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[HISTÓRICO NÃO OFICIAL]]></text>

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="grupoPeriodo" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

mode="Opaque"

x="266"

y="6"

width="287"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-1"

stretchType="NoStretch"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<box topBorder="Thin" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">

<font fontName="Luxi Sans" pdfFontName="Helvetica-Bold" size="8" isBold="true" isItalic=&q

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...