tono.yang Posted January 23, 2019 Share Posted January 23, 2019 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, DESCRIPTIONFROM CUST_TYPEWHERE 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> Link to comment Share on other sites More sharing options...
hozawa Posted January 24, 2019 Share Posted January 24, 2019 I just testing exporting to csv with Jaspersoft Studio 6.6.0 and didn't find any quotes at start and end of each line. 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