dawoodshamim Posted June 16, 2021 Share Posted June 16, 2021 Hello everyone,I'm facing an issue while generating csv from jasper report, extra seperator occuring only in 3 rows. Does anyone have solution?here is my jrxml <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="ClearingFileJasper" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="3c97f001-e8d4-47f6-9dcf-fa7f3c202cae"> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="net.sf.jasperreports.export.csv.field.delimiter" value=";"/> <property name="net.sf.jasperreports.export.csv.paginated" value="false"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <field name="RRN" class="java.lang.String"/> <field name="TRANSACTIONID" class="java.lang.String"/> <field name="MOBILE_NUMBER" class="java.lang.String"/> <field name="IDBASE" class="java.lang.String"/> <field name="NUMSSUBSCRIBER" class="java.lang.String"/> <field name="NUMCONTRACT" class="java.lang.String"/> <field name="NUMCARD" class="java.lang.String"/> <field name="CREATE_DATE" class="java.lang.String"/> <field name="AMOUNT" class="java.lang.String"/> <field name="CURRENCY" class="java.lang.String"/> <field name="TYPEOPERATION" class="java.lang.String"/> <field name="COUNTRY" class="java.lang.String"/> <field name="OPERATORNAME" class="java.lang.String"/> <title> <band height="61" splitType="Stretch"> <frame> <reportElement x="-4" y="16" width="562" height="29" uuid="1f90961f-aa38-4fb7-a5da-778b4cd8e9b6"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <staticText> <reportElement x="-1" y="12" width="50" height="18" uuid="cb2957d9-5698-458c-b3e8-3bfda66375de"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[Transaction_RAWBANK]]></text> </staticText> <staticText> <reportElement x="46" y="12" width="50" height="18" uuid="6214b33f-1077-446b-bc11-416fed94d553"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[transaction_canal]]></text> </staticText> <staticText> <reportElement x="87" y="12" width="50" height="18" uuid="a0cb7e8c-e9cc-4bd0-9893-a379a4a9deaf"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[No_telephone]]></text> </staticText> <staticText> <reportElement x="135" y="12" width="50" height="18" uuid="f893fd8d-e1e3-4fd7-8282-db38170f5631"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[idbase]]></text> </staticText> <staticText> <reportElement x="174" y="12" width="50" height="18" uuid="17bda1f1-e161-44eb-9147-47a5937f23c1"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[No_abonne]]></text> </staticText> <staticText> <reportElement x="220" y="12" width="50" height="18" uuid="3c837650-70ed-48e6-aab9-8aa0eab96811"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[contrat]]></text> </staticText> <staticText> <reportElement x="261" y="12" width="50" height="18" uuid="a8f6526e-ed88-4136-aacb-bae821805f14"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[No_carte]]></text> </staticText> <staticText> <reportElement x="309" y="12" width="50" height="18" uuid="a0336d2b-6bff-457c-8bb0-9daeb7759a35"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[date_transaction]]></text> </staticText> <staticText> <reportElement x="485" y="12" width="50" height="18" uuid="21222a00-b5b1-45a6-a454-6712f12832db"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[operateur]]></text> </staticText> <staticText> <reportElement x="458" y="12" width="50" height="18" uuid="5a907110-c9c8-442f-b988-a777068950b2"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[pays]]></text> </staticText> <staticText> <reportElement x="416" y="12" width="50" height="18" uuid="ddf0e871-3c07-4cea-ad9b-6e6d8dba759b"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[operation]]></text> </staticText> <staticText> <reportElement x="382" y="12" width="50" height="18" uuid="7aacd8c3-6b59-44e7-bea8-5b6d2df164fc"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[devise]]></text> </staticText> <staticText> <reportElement x="343" y="12" width="50" height="18" uuid="2ff569da-3937-45ae-b8b4-2077460423aa"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center"/> <text><![CDATA[Montant]]></text> </staticText> </frame> </band> </title> <detail> <band height="294" splitType="Stretch"> <frame> <reportElement x="-4" y="131" width="562" height="32" uuid="d93ec1c1-2a83-480e-ab56-9cd0f380565c"/> <textField isBlankWhenNull="true"> <reportElement x="-1" y="2" width="50" height="21" uuid="813650b9-9764-4d67-b944-5fe103c5f0ad"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{RRN} == null ? "" : $F{RRN}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="41" y="2" width="50" height="21" uuid="ea9b54e9-b630-401c-9c5e-8bbd200655d5"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{TRANSACTIONID} == null ? "" : $F{TRANSACTIONID}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="83" y="2" width="50" height="21" uuid="fadbca2f-afdd-4005-bf4a-168798d3ecb1"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{MOBILE_NUMBER}==null ? "" : $F{MOBILE_NUMBER}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="128" y="2" width="50" height="21" uuid="fe90d727-3afa-4a6c-8734-aa6c8a5ebdf1"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{IDBASE} == null ? "" : $F{IDBASE}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="174" y="2" width="50" height="21" uuid="832233c4-feb6-435d-bbd0-2c17f2466539"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{NUMSSUBSCRIBER} == null ? "" : $F{NUMSSUBSCRIBER}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="225" y="2" width="50" height="21" uuid="576f830a-7161-4379-b057-c8ffb12650ba"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{NUMCONTRACT} == null ? "" : $F{NUMCONTRACT}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="262" y="2" width="50" height="21" uuid="d176fd89-57b2-4899-a251-cf4d2bb9cd1a"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{NUMCARD} == null ? "" : $F{NUMCARD}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="305" y="2" width="50" height="21" uuid="6c6303d0-e305-44d8-b3ce-ed7b9d8e8862"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{CREATE_DATE} == null ? "" : $F{CREATE_DATE}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="468" y="2" width="50" height="21" uuid="3ac7a152-333f-4002-88de-87a6d410a99b"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{COUNTRY} == null ? "" : $F{COUNTRY}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="425" y="2" width="50" height="21" uuid="79ac90ab-68f2-45db-a38d-58f3df1af3be"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{TYPEOPERATION} == null ? "" : $F{TYPEOPERATION}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="388" y="2" width="50" height="21" uuid="36c97360-5bed-4d3c-99a7-0593383f0599"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{CURRENCY} == null ? "" : $F{CURRENCY}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="337" y="2" width="50" height="21" uuid="7646f826-bd39-465e-af99-b82914fe364c"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{AMOUNT} == null ? "" : $F{AMOUNT}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="508" y="2" width="50" height="21" uuid="5e716b61-8042-4ebf-b853-3947f0c36bea"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[$F{OPERATORNAME} == null ? "" : $F{OPERATORNAME}]]></textFieldExpression> </textField> </frame> </band> </detail></jasperReport> Link to comment Share on other sites More sharing options...
Tom C Posted June 16, 2021 Share Posted June 16, 2021 1) You need to make perfect alignment for all fields in vertical direction;2) Do not overlap fields. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now