ireport: horizontal report is cutting off the last line

0

Currently my ireport generates report vertically and all of the data shows up properly. in example:

  vertical report

 

When i convert the report to horizontal report it cuts of the last line "{Hard Copy - Regular Mail}" Only prints out:

 

horizontal report

 

Here is my xml code for my horizontal report:

<?xml version="1.0" encoding="UTF-8"?><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="Service Sheet Preview" columnCount="2" printOrder="Horizontal" pageWidth="612" pageHeight="792" columnWidth="286" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <style name="table">  <box>   <pen lineWidth="1.0" lineColor="#000000"/>  </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF">  <box>   <pen lineWidth="0.5" lineColor="#000000"/>  </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF">  <box>   <pen lineWidth="0.5" lineColor="#000000"/>  </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">  <box>   <pen lineWidth="0.5" lineColor="#000000"/>  </box> </style> <subDataset name="Recipients">  <field name="RECIPIENTS" class="java.lang.String"/> </subDataset> <parameter name="CSNL_ID" class="java.lang.String">  <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="DOC_ID" class="java.lang.String">  <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="PREVIEW" class="java.lang.String">  <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString>  <![CDATA[select      distinct(csnl.id),STUFF(      (SELECT ', ' + clmt.C_LAST_NAME + ', ' + clmt.C_FIRST_NAME + ' V. ' + emplr.C_LAST_NAME + ', ' + emplr.C_FIRST_NAME            from T_CSNL_RELATED_CASE d            inner join T_CASE_INPUT c on d.C_CASE_ID = c.ID            left join T_CONTACT clmt on cast(c.C_CLAIMANT_ID as int) = clmt.ID            left join T_CONTACT emplr on cast (c.C_EMPLOYER_ID as int) = emplr.ID            where d.ID_BASE = csnl.id            FOR XML PATH(''))            , 1,1,'')as CASE_NAME,     STUFF(      (SELECT ', ' + C_CASE_NUMBER            from T_CSNL_RELATED_CASE d            where d.ID_BASE = csnl.id            FOR XML PATH(''))            , 1,1,'') AS CASE_NUMBER,     (select c_title from t_document doc where id = $P{DOC_ID}) as TITLE,     case when datepart(dd, getdate()) in(01, 21, 31) then convert(varchar, datepart(dd, getdate()))+'st'          when datepart(dd, getdate()) in(02, 22) then convert(varchar, datepart(dd, getdate()))+'nd'          when datepart(dd, getdate()) in(03, 23) then convert(varchar, datepart(dd, getdate()))+'rd'          else convert(varchar, datepart(dd, getdate()))+'th'     end as DAY,     datename(mm, getdate()) as MONTH,     datepart(yyyy, getdate()) as YEAR,case when ct.c_title is null OR ct.c_title = '' then '' else ct.c_title+'<br>' end+                                                       case when ct.c_organization is null OR ct.c_organization = '' then '' else ct.c_organization+'<br>' end+                                ct.c_first_name+' '+ct.c_last_name +'<br>'+                                                                                                                                dbo.OALJ_getContactAddress(ct.id, default) +'<br>'                    +'<br>       {'+dt.c_name+'}'                     as RECIPIENTS,                                rcpts.C_ORDER as displayOrderfrom t_csnl csnl       join t_csnl_related_case csnlRC on csnl.id = csnlRC.id_base      join (select id_base, c_contact, c_delivery_type, c_order from T_CSNL_ESR_RCPTS where id_base = $P{CSNL_ID}               UNION select id_base, c_contact, c_delivery_type, c_order from T_CSNL_HARD_COPY_RCPTS where id_base = $P{CSNL_ID}               UNION select id_base, c_contact, c_delivery_type, c_order from T_CSNL_STANDARD_RCPTS where id_base = $P{CSNL_ID}) rcpts on csnl.id = rcpts.id_base      join t_contact ct on ct.id = rcpts.c_contact     join t_csnl_delivery_type dt on dt.id = rcpts.c_delivery_type      join t_case_input cs on csnlRC.c_case_id = cs.id     join t_document doc on doc.id = $P{DOC_ID}where csnl.id = $P{CSNL_ID} ORDER BY displayOrder ASC, 8 ASC]]> </queryString> <field name="id" class="java.math.BigDecimal"/> <field name="CASE_NAME" class="java.lang.String"/> <field name="CASE_NUMBER" class="java.lang.String"/> <field name="TITLE" class="java.lang.String"/> <field name="DAY" class="java.lang.String"/> <field name="MONTH" class="java.lang.String"/> <field name="YEAR" class="java.lang.Integer"/> <field name="RECIPIENTS" class="java.lang.String"/> <field name="displayOrder" class="java.lang.Integer"/> <variable name="RUNDATE" class="java.lang.String">  <variableExpression><![CDATA[(new SimpleDateFormat("yyyy/MM/dd")).format(new Date())]]></variableExpression> </variable> <group name="ReportGroup1">  <groupExpression><![CDATA[$F{CASE_NAME}]]></groupExpression>  <groupHeader>   <band height="148">    <staticText>     <reportElement x="0" y="20" width="100" height="20"/>     <textElement>      <font fontName="Times New Roman"/>     </textElement>     <text><![CDATA[Case Number:]]></text>    </staticText>    <textField isStretchWithOverflow="true" isBlankWhenNull="true">     <reportElement x="100" y="20" width="472" height="20"/>     <textElement>      <font fontName="Times New Roman" isBold="true" pdfFontName="Times-Bold"/>     </textElement>     <textFieldExpression class="java.lang.String"><![CDATA[$F{CASE_NUMBER}]]></textFieldExpression>    </textField>    <staticText>     <reportElement x="0" y="40" width="100" height="20"/>     <textElement>      <font fontName="Times New Roman"/>     </textElement>     <text><![CDATA[Document Title:]]></text>    </staticText>    <textField isStretchWithOverflow="true" isBlankWhenNull="true">     <reportElement x="100" y="40" width="472" height="20"/>     <textElement>      <font fontName="Times New Roman" isBold="true" pdfFontName="Times-Bold" isPdfEmbedded="true"/>     </textElement>     <textFieldExpression class="java.lang.String"><![CDATA[$F{TITLE}]]></textFieldExpression>    </textField>    <staticText>     <reportElement x="0" y="0" width="100" height="20"/>     <textElement>      <font fontName="Times New Roman"/>     </textElement>     <text><![CDATA[Case Name:]]></text>    </staticText>    <textField>     <reportElement x="100" y="0" width="472" height="20"/>     <textElement>      <font fontName="Times New Roman" isBold="true" pdfFontName="Times-Bold"/>     </textElement>     <textFieldExpression class="java.lang.String"><![CDATA[$F{CASE_NAME}]]></textFieldExpression>    </textField>    <textField>     <reportElement x="0" y="60" width="572" height="28"/>     <textElement>      <font fontName="Times New Roman"/>     </textElement>     <textFieldExpression class="java.lang.String"><![CDATA["I hereby certify that a copy of the above-referenced document was sent to the following this "+$F{DAY}+" day of "+$F{MONTH}+", "+$F{YEAR}+":"]]></textFieldExpression>    </textField>    <textField>     <reportElement x="0" y="88" width="572" height="60"/>     <textElement>      <font fontName="Times New Roman" size="14" isBold="true" isItalic="true" isUnderline="false"/>     </textElement>     <textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>    </textField>   </band>  </groupHeader> </group> <background>  <band height="752" splitType="Stretch">   <printWhenExpression><![CDATA[$P{PREVIEW}.equals( "Yes" )]]></printWhenExpression>   <staticText>    <reportElement x="0" y="92" width="572" height="64" forecolor="#CCCCCC" backcolor="#FFFFFF"/>    <textElement textAlignment="Center">     <font size="48" isBold="true"/>    </textElement>    <text><![CDATA[PREVIEW]]></text>   </staticText>   <staticText>    <reportElement x="0" y="220" width="572" height="64" forecolor="#CCCCCC"/>    <textElement textAlignment="Center">     <font size="48" isBold="true"/>    </textElement>    <text><![CDATA[PREVIEW]]></text>   </staticText>   <staticText>    <reportElement x="0" y="348" width="572" height="64" forecolor="#CCCCCC"/>    <textElement textAlignment="Center">     <font size="48" isBold="true"/>    </textElement>    <text><![CDATA[PREVIEW]]></text>   </staticText>   <staticText>    <reportElement x="0" y="476" width="572" height="64" forecolor="#CCCCCC"/>    <textElement textAlignment="Center">     <font size="48" isBold="true"/>    </textElement>    <text><![CDATA[PREVIEW]]></text>   </staticText>   <staticText>    <reportElement x="0" y="604" width="572" height="64" forecolor="#CCCCCC"/>    <textElement textAlignment="Center">     <font size="48" isBold="true"/>    </textElement>    <text><![CDATA[PREVIEW]]></text>   </staticText>  </band> </background> <title>  <band height="34" splitType="Stretch">   <staticText>    <reportElement x="0" y="0" width="572" height="27"/>    <textElement textAlignment="Center">     <font fontName="Times New Roman" size="20" isBold="true" isUnderline="false"/>    </textElement>    <text><![CDATA[SERVICE SHEET]]></text>   </staticText>  </band> </title> <detail>  <band height="42">   <textField isStretchWithOverflow="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="284" height="20" isPrintWhenDetailOverflows="true"/>    <textElement markup="html">     <font fontName="Times New Roman" pdfFontName="Times-Roman" isPdfEmbedded="true"/>     <paragraph spacingAfter="20"/>    </textElement>    <textFieldExpression class="java.lang.String"><![CDATA[$F{RECIPIENTS}+"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]]></textFieldExpression>   </textField>  </band> </detail> <summary>  <band height="50">   <printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==0)]]></printWhenExpression>   <staticText>    <reportElement x="0" y="30" width="572" height="20"/>    <textElement textAlignment="Center">     <font size="12"/>    </textElement>    <text><![CDATA[Your selection has returned no results]]></text>   </staticText>  </band> </summary></jasperReport>
rahman.reazur's picture
Joined: Jul 6 2016 - 12:03pm
Last seen: 2 years 10 months ago

0 Answers:

No answers yet
Feedback
randomness