Totals per group and report

2006 IR Open Dicussion · August 27, 2006

By: Ana - ana_abrantes

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:

<initialValueExpression><![CDATA[new

Double(0)]]></initialValueExpression>

</variable>

<initialValueExpression><![CDATA[new

Double(0)]]></initialValueExpression>

</variable>

The corresponding returnValues:

(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>

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" ?>

<!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">

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</band>

</groupHeader>

</band>

</groupFooter>

</group>

</band>

</groupHeader>

<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>

</subreport>

<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"/>

</textElement>

</staticText>

</band>

</groupFooter>

</group>

</band>

</groupHeader>

<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"/>

</textElement>

</textField>

<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"/>

</line>

</band>

</groupFooter>

</group>

<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"/>

</line>

</band>

</groupHeader>

<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"/>

</textElement>

</textField>

<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"/>

</line>

</band>

</groupFooter>

</group>

</band>

</groupHeader>

</band>

</groupFooter>

</group>

<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"/>

</textElement>

</textField>

</band>

</groupHeader>

</band>

</groupFooter>

</group>

<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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</staticText>

</band>

</groupHeader>

</band>

</groupFooter>

</group>

<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"/>

</rectangle>

<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"/>

</rectangle>

<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"/>

</textElement>

<text><![CDATA[A - 3

B - 2

C - 1

D - 0

I - Incompleto]]></text>

</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"/>

</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>

<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"/>

</textElement>

</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"/>

</textElement>

</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"/>

</textElement>

</staticText>

<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"/>

</textElement>

</textField>

<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"/>

</textElement>

</textField>

<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"/>

</line>

<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"/>

</textElement>

</staticText>

</band>

</background>

<title>

</band>

</title>

<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"/>

</rectangle>

<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"/>

</image>

<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"/>

</textElement>

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

Cidade UniversitÃƒÂ¡ria - Ilha do FundÃƒÂ£o]]></text>

</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"/>

</textElement>

</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"/>

</textElement>

</staticText>

<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"/>

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

Sign In

Totals per group and report

Recommended Posts

2006 IR Open Dicussion

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore