Hi, I create some Jasper and output into csv file. However I notice Jasper automatically enclosed double quote at the start and end of the line. I have attached the jrxml below, any advise or example to output Jasper into csv format? <?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="cust_type_report_csv" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="595" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" scriptletClass="com.symphony.WMSScriptlet" uuid="35859cda-47e0-4abd-8fe9-2152460e5966"> <property name="ireport.zoom" value="1.331000000000001"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="P_REP_KEY" class="java.lang.String"/> <parameter name="P_REP_PWD" class="java.lang.String"/> <parameter name="P_MENU_ID" class="java.lang.String"/> <parameter name="P_FROM" class="java.lang.String"/> <parameter name="P_TO" class="java.lang.String"/> <parameter name="P_JRSEPARATOR" class="java.lang.String"/> <queryString> <![CDATA[sELECT CUST_TYPE, DESCRIPTION FROM CUST_TYPE WHERE CUST_TYPE >= $P{P_FROM} AND CUST_TYPE<= $P{P_TO} ORDER BY CUST_TYPE]]> </queryString> <field name="CUST_TYPE" class="java.lang.String"/> <field name="DESCRIPTION" class="java.lang.String"/> <variable name="V_SESSION_ID" class="java.lang.Integer" calculation="System"/> <variable name="V_MENU_DESC" class="java.lang.String" calculation="System"/> <variable name="V_ENTITY" class="java.lang.String" calculation="System"/> <variable name="V_ENTITY_NAME" class="java.lang.String" calculation="System"/> <variable name="V_LANGUAGE" class="java.lang.String" calculation="System"/> <variable name="V_MODULE_ID" class="java.lang.String" calculation="System"/> <variable name="V_REPORT_ID_LABEL" class="java.lang.String" calculation="System"/> <variable name="V_PAGE_LABEL" class="java.lang.String" calculation="System"/> <variable name="V_RUN_DATE_LABEL" class="java.lang.String" calculation="System"/> <variable name="V_DATE_FORMAT" class="java.lang.String" calculation="System"/> <variable name="V_TIME_FORMAT" class="java.lang.String" calculation="System"/> <variable name="V_RUN_DATE" class="java.lang.String" calculation="System"/> <variable name="V_JRSEPARATOR" class="java.lang.String"> <variableExpression><![CDATA[($P{P_JRSEPARATOR}.equalsIgnoreCase("TAB")) ? "t" : ($P{P_JRSEPARATOR}.equalsIgnoreCase("COMMA")) ? "," : $P{P_JRSEPARATOR}]]></variableExpression> <initialValueExpression><![CDATA[($P{P_JRSEPARATOR}.equalsIgnoreCase("TAB")) ? "t" : ($P{P_JRSEPARATOR}.equalsIgnoreCase("COMMA")) ? "," : $P{P_JRSEPARATOR}]]></initialValueExpression> </variable> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="30"> <textField isBlankWhenNull="true"> <reportElement x="0" y="0" width="595" height="15" uuid="d8ddeba4-3460-4785-ba7a-115eda64d4d9"/> <textElement> <font fontName="Arial Unicode MS" size="8" isBold="false" pdfEncoding="Identity-H" isPdfEmbedded="true"/> </textElement> <textFieldExpression><![CDATA[$V{V_MENU_DESC} + $V{V_JRSEPARATOR} + $V{V_RUN_DATE_LABEL} + ":" + $V{V_RUN_DATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="15" width="595" height="15" uuid="e93a1158-6761-4f1e-9049-cfa8fc87bd5b"/> <textElement> <font fontName="Arial Unicode MS" size="8" isBold="false" pdfEncoding="Identity-H" isPdfEmbedded="true"/> </textElement> <textFieldExpression><![CDATA[$V{V_ENTITY_NAME}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="15"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="595" height="15" uuid="cd8c0ac6-ea2d-42fa-85d5-98381c1db594"/> <textElement> <font fontName="Arial Unicode MS" size="8" isItalic="false" pdfEncoding="Identity-H" isPdfEmbedded="true"/> </textElement> <textFieldExpression><![CDATA[$P{REPORT_SCRIPTLET}.getComment("CUST_TYPE", "CUST_TYPE", $V{V_SESSION_ID}) + $V{V_JRSEPARATOR} + $P{REPORT_SCRIPTLET}.getComment("CUST_TYPE", "DESCRIPTION", $V{V_SESSION_ID})]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="15" splitType="Stretch"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="595" height="15" uuid="295de096-86a9-4870-87d8-60617a3dbebb"/> <textElement> <font fontName="Arial Unicode MS" size="8" isItalic="false" pdfEncoding="Identity-H" isPdfEmbedded="true"/> </textElement> <textFieldExpression><![CDATA[$F{CUST_TYPE} + $V{V_JRSEPARATOR} + $F{DESCRIPTION}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="15"> <textField> <reportElement positionType="Float" x="0" y="0" width="595" height="15" uuid="d34636a4-fd51-46b4-bbef-d8d39983aa9c"/> <textElement> <font fontName="Arial Unicode MS" size="8" pdfEncoding="Identity-H" isPdfEmbedded="true"/> </textElement> <textFieldExpression><![CDATA[$V{V_MODULE_ID}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>
