Jump to content
Changes to the Jaspersoft community edition download ×

String Field blanked out when too long, report hangs when even longer


scottz
Go to solution Solved by scottz,

Recommended Posts

I've got a field in a report (notes) that when the number of characters in the field is 92 or less, everything prints out.  When the content is greater than 92 characters, nothing prints out.  When the content is greater than ~1000 characters, the report hangs.

 

Below are relevant portions of the source:

<field name="notes" class="java.lang.String">
<fieldDescription><![CDATA[notes]]></fieldDescription>
</field>
 
...
<band height="20">
<staticText>
<reportElement positionType="FixRelativeToBottom" mode="Transparent" x="1" y="0" width="80" height="20" forecolor="#000000" backcolor="#F2EBDF" uuid="ebc6dab4-7684-4ad0-b23a-11e155c43d91"/>
<textElement verticalAlignment="Top">
<font isBold="true"/>
</textElement>
<text><![CDATA[Notes:]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="FixRelativeToBottom" stretchType="ElementGroupHeight" x="82" y="0" width="489" height="20" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" uuid="c963612d-d4e5-4dbe-b351-2a6ead5be9fe"/>
<box>
<pen lineWidth="1.0"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement verticalAlignment="Top">
<font isStrikeThrough="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{notes}]]></textFieldExpression>
</textField>
</band>
 
Does anyone have any suggestions?  In other reports that display the same field, there are no issues.  I've compared the setup for the field in the non-working report versus working reports and have not spotted and differences.
 
Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

I could able to print more than 1000 characters from a field. may be your jrxml would have some properties which limit the printing.

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0  --><!-- 2017-02-28T08:27:26 --><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="Blank_A4_Landscape" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bf32be87-78c5-45ea-95c8-7ba97a927382">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <queryString>        <![CDATA[select * from notes  ewhere length(e.comments) > 1000]]>    </queryString>    <field name="COMMENTS" class="java.lang.String"/>    <background>        <band splitType="Stretch"/>    </background>    <detail>        <band height="110" splitType="Stretch">            <textField isStretchWithOverflow="true" isBlankWhenNull="true">                <reportElement x="0" y="0" width="802" height="110" uuid="f3090521-ad86-476b-8808-a0448005a8a0"/>                <textFieldExpression><![CDATA[$F{COMMENTS}]]></textFieldExpression>            </textField>        </band>    </detail></jasperReport>[/code]

 

Link to comment
Share on other sites

Reducing the font size increases the number of characters that the field will display.  If the font is reduced to 6pt, 2 lines of text will be displayed, but once there is more than 2 lines worth of text to display, nothing will be displayed.  So, it looks like it is not properly handling the "stretch with overflow".  

 

Below is all of the source:

 

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1  -->
<!-- 2017-02-28T11:35:46 -->
<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="RadioLogReport" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="04f6a713-1413-455e-b471-ffff54a2c463">
<property name="ireport.zoom" value="1.3310000000000237"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="DPSS_LOGO" class="java.lang.String">
<defaultValueExpression><![CDATA[new java.lang.String("C:\Users\Administrator\workspace\DPS\WebContent\images\dynamic-public-safety-logo.png")]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[]]>
</queryString>
<field name="updatedUser" class="java.lang.Integer">
<fieldDescription><![CDATA[updatedUser]]></fieldDescription>
</field>
<field name="notes" class="java.lang.String">
<fieldDescription><![CDATA[notes]]></fieldDescription>
</field>
<field name="location" class="java.lang.String">
<fieldDescription><![CDATA[location]]></fieldDescription>
</field>
<field name="incident" class="java.lang.Boolean">
<fieldDescription><![CDATA[incident]]></fieldDescription>
</field>
<field name="createdUser" class="java.lang.Integer">
<fieldDescription><![CDATA[createdUser]]></fieldDescription>
</field>
<field name="codeTableByCallType" class="com.dc.dpss.db.hibernate.CodeTable">
<fieldDescription><![CDATA[codeTableByCallType]]></fieldDescription>
</field>
<field name="agencyByAgencyId" class="com.dc.dpss.db.hibernate.Agency">
<fieldDescription><![CDATA[agencyByAgencyId]]></fieldDescription>
</field>
<field name="logTime" class="java.util.Date">
<fieldDescription><![CDATA[logTime]]></fieldDescription>
</field>
<field name="accident" class="java.lang.Boolean">
<fieldDescription><![CDATA[accident]]></fieldDescription>
</field>
<field name="agencyByRadiologAgency" class="com.dc.dpss.db.hibernate.Agency">
<fieldDescription><![CDATA[agencyByRadiologAgency]]></fieldDescription>
</field>
<group name="All Entries" keepTogether="true">
<groupExpression><![CDATA[$V{PAGE_NUMBER}]]></groupExpression>
<groupHeader>
<band height="21">
<staticText>
<reportElement mode="Transparent" x="1" y="1" width="96" height="20" forecolor="#000000" backcolor="#F2EBDF" uuid="74de19aa-7d31-47c4-b92c-0f785584196b"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Date/Time]]></text>
</staticText>
<staticText>
<reportElement mode="Transparent" x="97" y="1" width="90" height="20" forecolor="#000000" backcolor="#F2EBDF" uuid="bdece7dd-52aa-4d5b-8f17-19716abd09ff"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Type]]></text>
</staticText>
<line>
<reportElement x="0" y="0" width="572" height="1" uuid="d2d3dcee-9bba-4151-8858-6daa6f1872d6"/>
</line>
<staticText>
<reportElement mode="Transparent" x="187" y="1" width="185" height="20" forecolor="#000000" backcolor="#F2EBDF" uuid="802520bc-f892-4b74-9651-124a4d930bc4"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Agency]]></text>
</staticText>
<line>
<reportElement stretchType="RelativeToBandHeight" x="0" y="1" width="1" height="20" isPrintWhenDetailOverflows="true" uuid="df893006-6c7e-4455-8df3-db6623862208"/>
</line>
<line>
<reportElement stretchType="RelativeToBandHeight" x="571" y="1" width="1" height="20" isPrintWhenDetailOverflows="true" uuid="43d7cf25-5bd1-41cd-9dfb-b50c7d0907de"/>
</line>
<staticText>
<reportElement mode="Transparent" x="372" y="1" width="199" height="20" forecolor="#000000" backcolor="#F2EBDF" uuid="a8eba13d-024d-4653-b1f7-5217d00c9c49"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Location]]></text>
</staticText>
</band>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<group name="Date/Time Called" keepTogether="true">
<groupExpression><![CDATA[$V{PAGE_NUMBER}]]></groupExpression>
<groupHeader>
<band/>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<group name="Agency" keepTogether="true">
<groupExpression><![CDATA[$V{PAGE_NUMBER}]]></groupExpression>
<groupHeader>
<band/>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<group name="Type of Call">
<groupExpression><![CDATA[$V{PAGE_NUMBER}]]></groupExpression>
<groupHeader>
<band/>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<group name="Location">
<groupExpression><![CDATA[$V{PAGE_NUMBER}]]></groupExpression>
<groupHeader>
<band/>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="80" splitType="Stretch">
<staticText>
<reportElement x="109" y="0" width="422" height="62" uuid="07bbe494-bcbf-4894-a816-a712c838b610"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Times New Roman" size="36"/>
</textElement>
<text><![CDATA[Radio Log Summary Report]]></text>
</staticText>
<image>
<reportElement x="0" y="0" width="80" height="80" uuid="cc253f91-2116-4bf8-ae78-3934dfa0926d"/>
<imageExpression><![CDATA[$P{DPSS_LOGO}]]></imageExpression>
</image>
</band>
</title>
<pageHeader>
<band splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band splitType="Stretch"/>
</columnHeader>
<detail>
<band height="22" splitType="Stretch">
<textField isStretchWithOverflow="true" pattern="MM/dd/yyyy HH:mm" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="1" y="1" width="96" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC" uuid="8c86f11a-27d7-4663-b020-27c493efa40d"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{logTime}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="97" y="1" width="90" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC" uuid="275b70f6-726a-4a4e-b9d8-d5c922bcc826"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[new java.lang.String($F{codeTableByCallType} == null?"":($F{codeTableByCallType}.getName()))]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="187" y="1" width="185" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC" uuid="297ed127-bf83-4ec3-9cff-8c8ac592250b"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[new java.lang.String($F{agencyByRadiologAgency} == null?"":($F{agencyByRadiologAgency}.getName()))]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" mode="Transparent" x="372" y="1" width="199" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC" uuid="396dc121-dcf5-447f-b6d5-fab476c1433f"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{location}]]></textFieldExpression>
</textField>
<line>
<reportElement stretchType="RelativeToBandHeight" x="0" y="1" width="1" height="20" isPrintWhenDetailOverflows="true" uuid="f8457150-0fa7-4e01-8961-406765280b34"/>
</line>
<line>
<reportElement x="0" y="0" width="572" height="1" uuid="0b7835e9-9c1f-4d17-9fb0-ee372f09b9e4"/>
</line>
<line>
<reportElement stretchType="RelativeToBandHeight" x="571" y="1" width="1" height="20" isPrintWhenDetailOverflows="true" uuid="52a1f3b4-a4fc-45e7-ba71-c2cd35fdf1eb"/>
</line>
<line>
<reportElement positionType="FixRelativeToBottom" x="0" y="21" width="572" height="1" uuid="8a76373e-40cb-4a39-a05a-ae545eb21256"/>
</line>
</band>
<band height="20">
<staticText>
<reportElement positionType="FixRelativeToBottom" mode="Transparent" x="1" y="0" width="80" height="20" forecolor="#000000" backcolor="#F2EBDF" uuid="ebc6dab4-7684-4ad0-b23a-11e155c43d91"/>
<textElement verticalAlignment="Top">
<font isBold="true"/>
</textElement>
<text><![CDATA[Notes:]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="FixRelativeToBottom" x="82" y="0" width="489" height="20" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" uuid="496b6395-df7a-4327-8ef2-ef621c35b897"/>
<textElement verticalAlignment="Top">
<font isStrikeThrough="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{notes}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="25" splitType="Stretch">
<frame>
<reportElement mode="Opaque" x="0" y="0" width="572" height="25" forecolor="#D0B48E" backcolor="#CCCCCC" uuid="75350b8d-482b-432a-bbbe-24f088df633c"/>
<textField evaluationTime="Report">
<reportElement x="81" y="0" width="40" height="25" forecolor="#000000" uuid="ddf5b025-1d98-458e-a1fe-29db5c26c47b"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="0" width="82" height="25" forecolor="#000000" uuid="4b418e01-c2c1-4b99-9781-25769a8ab7a0"/>
<textElement textAlignment="Right" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
</textField>
<textField pattern="MMMMM dd, yyyy">
<reportElement x="464" y="0" width="108" height="25" forecolor="#000000" uuid="90e7bc61-5a71-404f-93c3-73812a29d29c"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</frame>
</band>
</pageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
<noData>
<band height="120">
<staticText>
<reportElement x="0" y="80" width="572" height="40" uuid="245ed936-46c3-49e6-a7ab-d606818a43e6"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="24"/>
</textElement>
<text><![CDATA[No Data]]></text>
</staticText>
<image>
<reportElement x="0" y="0" width="80" height="80" uuid="e8ddc4ba-1f53-4f5e-824b-8870b3942b97"/>
<imageExpression><![CDATA[$P{DPSS_LOGO}]]></imageExpression>
</image>
<staticText>
<reportElement x="109" y="0" width="422" height="62" uuid="121fd14b-6e4b-4777-bb08-6383b9034c8d"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Times New Roman" size="36"/>
</textElement>
<text><![CDATA[Radio Log Summary Report]]></text>
</staticText>
</band>
</noData>
</jasperReport>
 
Link to comment
Share on other sites

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