Help, what am I doing wrong with subreports

[2001 JI Open Discussion]

By: Jeff Cooper - jcooper

Help, what am I doing wrong with subreports

2002-11-12 05:18

I am trying to design a report where the main report prints out information on an account and the subreport will print out any jobs for that account. Here is what I have for my master repor (I'll just copy the subreport section):

 

<subreport isUsingCache="true">

<reportElement

mode="Transparent"

x="1"

y="34"

width="526"

height="41"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="true"

isPrintInFirstWholeBand="true"

isPrintWhenDetailOverflows="false"/>

<connectionExpression>

$P{REPORT_CONNECTION}

</connectionExpression>

<subreportExpression class="java.lang.String">

"Jobs.jasper"

</subreportExpression>

</subreport>

And here is the subreport:

 

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

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="535"

columnSpacing="0"

leftMargin="30"

rightMargin="30"

topMargin="20"

bottomMargin="20"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<parameter name="AccountId" isForPrompting="false" class="java.lang.Integer"/>

<queryString><![CDATA[

SELECT Job.Summary from Job where Job.Id = $P{AccountId}

]]></queryString>

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

<variable name="test" class="java.lang.String" resetType="None" calculation="Nothing">

<variableExpression>"test"</variableExpression>

<initialValueExpression>"test" </initialValueExpression>

</variable>

<title>

<band height="3">

</band>

</title>

<pageHeader>

<band height="9">

</band>

</pageHeader>

<columnHeader>

<band height="0">

</band>

</columnHeader>

<detail>

<band height="26">

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="126"

y="4"

width="398"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" lineSpacing="Single">

<font fontName="" pdfFontName="Times-Roman" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String">$F{Summary}</textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Transparent"

x="0"

y="10"

width="127"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" lineSpacing="Single">

<font fontName="" pdfFontName="Times-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

</textElement>

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

</staticText>

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="27">

</band>

</pageFooter>

<summary>

<band height="0">

</band>

</summary>

</jasperReport>

 

 

I modified the subreportapp to use my files and did the following, ant javac, ant compile, ant fill, and finally ant pdf. The only data that is printing out are the accounts but not the jobs associated with the accounts.

 

Thanks for any help,

Jeff Cooper

 

 

 

 

By: Sofiane - sofianito

RE: Help, what am I doing wrong with subrepor

2002-11-12 08:05

I think u have to specify the full path of jobs.jasper, i had the same problem with images, i introduced a parameter in the master report which the base directory where the images where located.

 

good luck

Sofiane

 

 

By: Jeffrey S. Cooper - jscooper

RE: Help, what am I doing wrong with subreports

2002-11-12 09:10

Just tried putting in the path to the subreport; but no, it's still not printing out the subreport records.

 

Thanks,

Jeff Cooper

 

 

By: Giulio Toffoli - gt78

RE: Help, what am I doing wrong with subreports

2002-11-13 13:52

You must add a subreport parameter to pass the value of AccountID to the subreport.

 

Giulio