Fields not printing from query

[2002 JI Open Discussion]

By: Ryan - louier79

Fields not printing from query

2003-08-18 14:26

Hello,

 

The fields are not printing the results from the query and I verified the query.

 

Here is the xml code:

--------------------

<jasperReport

name="Bill_Summary"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="612"

pageHeight="35"

columnWidth="612"

columnSpacing="0"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<queryString><![CDATA[sELECT ACTIVITY_THROUGH, DATE_DUE, BILLING_HOURS, PAYMENT_OR_CREDIT_DUE, PAYMENT_OR_CREDIT_AMOUNT FROM BRS_WEBBILLS_ACCOUNT_SUMMARY WHERE SID = '522-31-6590' AND ACTIVITY_THROUGH = to_date('03/14/03','MM/DD/YY')]]></queryString>

<field name="ACTIVITY_THROUGH" class="java.util.Date"/>

<field name="DATE_DUE" class="java.util.Date"/>

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

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

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

<background>

<band height="0">

</band>

</background>

<title>

<band height="0">

</band>

</title>

<pageHeader>

<band height="0">

</band>

</pageHeader>

<columnHeader>

<band height="35">

<staticText>

<reportElement

mode="Transparent"

x="75"

y="10"

width="65"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font fontName="sansserif" pdfFontName="LTYPEB.TTF" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<text>Billing Hours</text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="190"

y="10"

width="80"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font fontName="sansserif" pdfFontName="LTYPEB.TTF" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<text>Activity Through</text>

</staticText>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="45"

y="5"

width="522"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="45"

y="34"

width="522"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

</line>

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

mode="Transparent"

x="340"

y="10"

width="135"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">

<font fontName="sansserif" pdfFontName="LTYPEB.TTF" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

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

</textField>

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

mode="Transparent"

x="500"

y="10"

width="55"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">

<font fontName="sansserif" pdfFontName="LTYPEB.TTF" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

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

</textField>

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

mode="Transparent"

x="75"

y="20"

width="65"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font fontName="sansserif" pdfFontName="LTYPE.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

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

</textField>

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

mode="Transparent"

x="190"

y="20"

width="80"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font fontName="sansserif" pdfFontName="LTYPE.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[new SimpleDateFormat("MM/dd/yy").format($F{ACTIVITY_THROUGH})]]></textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Transparent"

x="430"

y="20"

width="45"

height="10"

forecolor="#000000"

backcolor="#C0C0C0"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single">

<font fontName="sansserif" pdfFontName="LTYPE.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<text>Date Due</text>

</staticText>

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

mode="Transparent"

x="511"

y="20"

width="45"

height="10"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

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

<font fontName="sansserif" pdfFontName="LTYPE.TTF" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[new SimpleDateFormat("MM/dd/yy").format($F{DATE_DUE})]]></textFieldExpression>

</textField>

</band>

</columnHeader>

<detail>

<band height="0">

</band>

</detail>

<columnFooter>

<band height="0">

</band>

</columnFooter>

<pageFooter>

<band height="0">

</band>

</pageFooter>

<summary>

<band height="0">

</band>

</summary>

</jasperReport>

 

Thank you for your assistance and advise!

 

 

 

 

By: Gregory A. Swarthout - gswarthout

RE: Fields not printing from query

2003-08-18 14:37

Your "detail" section is blank. This is the section that gets repeated for each row of data returned by your query.

 

 

 

 

By: Ryan - louier79

RE: Fields not printing from query

2003-08-18 14:48

I moved the columnHeader fields to the details section/band and it is still not printing the fields. The report should only print five (5) fields from the query.

 

Any other suggestions? Thank you again for your help!!!

 

 

 

 

By: Gregory A. Swarthout - gswarthout

RE: Fields not printing from query

2003-08-18 15:00

Try increasing the height of each of the reportElements.

 

 

 

 

By: Ryan - louier79

RE: Fields not printing from query

2003-08-18 15:10

That was it!

 

Thank you! Thank you! Thank you!

 

Are you helping on the JasperReport project? You are always able to help me on issues and I really do appreciate it!