CSV metadata issue by just providing net.sf.jasperreports.export.csv.column.names

[vpatelgwu.edu]

Why  when attached report exported using CSV meta expoerter it produce balnk CSV. when net.sf.jasperreports.export.csv.column.names is setup at report level

This templete cn be run on any oracle database.

---

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 5.6.1.final using JasperReports Library version 5.6.1  --><!-- 2014-09-18T11:37:28 --><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="SZR2UGW_4896" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" scriptletClass="ar.com.fdvs.dj.core.DJDefaultScriptlet" whenResourceMissingType="Key" uuid="bfcd2bb3-90ae-4a97-ac0b-1a0d067ee66f"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="net.sf.jasperreports.export.xls.write.header" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> <property name="net.sf.jasperreports.export.csv.write.header" value="true"/> <property name="net.sf.jasperreports.export.xls.column.names" value="pidm,GWid,Full Name,Detail code,tier,Term code,Fee Amount,Course#,College,Tuition Amount,"/> <property name="net.sf.jasperreports.export.csv.column.names" value="pidm,GWid,Full Name,Detail code,tier,Term code,Fee Amount,Course#,College,Tuition Amount,"/> <property name="net.sf.jasperreports.export.pdf.size.page.to.content" value="true"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Banner DEVL (Baninst1)"/> <parameter name="ReportName" class="java.lang.String" isForPrompting="false"/> <parameter name="JobNumber" class="java.lang.Integer" isForPrompting="false"/> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">  <parameterDescription><![CDATA[]]></parameterDescription>  <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <queryString language="SQL">  <![CDATA[/* Formatted on 9/18/2014 11:16:03 AM (QP5 v5.267.14150.38599) */SELECT 1 "pidm",       'XXXXXX' "GWid",       'Last, First' "Full Name",       'XPF2' "Detail code",       DECODE ('XPF2',               'XPF1', 'TierI',               'XPF2', 'TierII',               'XPF3', 'TierIII',               'XPF4', 'TierIV',               'XPF5', 'TierV',               'LUNV', 'TierVI',               'None')          "tier",       '999999' "Term code",       999.99 "Fee Amount",       '12345' "Course#",       'College Name' "College",       8888.88 "Tuition Amount"  FROM DUALUNIONSELECT 2 "pidm",       'YYYYY' "GWid",       'Last2, First' "Full Name",       'XPF4' "Detail code",       DECODE ('XPF4',               'XPF1', 'TierI',               'XPF2', 'TierII',               'XPF3', 'TierIII',               'XPF4', 'TierIV',               'XPF5', 'TierV',               'LUNV', 'TierVI',               'None')          "tier",       '000000' "Term code",       5555.55 "Fee Amount",       '56789' "Course#",       'College Name2' "College",       7777.77 "Tuition Amount"  FROM DUALORDER BY 2, 4]]> </queryString> <field name="pidm" class="java.math.BigDecimal"/> <field name="GWid" class="java.lang.String"/> <field name="Full Name" class="java.lang.String"/> <field name="Detail code" class="java.lang.String"/> <field name="tier" class="java.lang.String"/> <field name="Term code" class="java.lang.String"/> <field name="Fee Amount" class="java.math.BigDecimal"/> <field name="Course#" class="java.lang.String"/> <field name="College" class="java.lang.String"/> <field name="Tuition Amount" class="java.math.BigDecimal"/> <background>  <band splitType="Stretch"/> </background> <title>  <band height="40" splitType="Stretch"/> </title> <pageHeader>  <band height="21" splitType="Stretch">   <textField>    <reportElement x="473" y="0" width="80" height="20" uuid="e8b23a97-a7fe-4f85-a970-2a80c6404fc0"/>    <textElement textAlignment="Right"/>    <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of " + $V{PAGE_NUMBER}]]></textFieldExpression>   </textField>   <line>    <reportElement x="0" y="20" width="555" height="1" uuid="4e33ef87-b9de-4501-a30a-08e20c5d38f6"/>   </line>  </band> </pageHeader> <columnHeader>  <band height="30">   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_pidm" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="40" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="a4bca4a1-91e5-461a-8618-a3ec06636561"/>    <textFieldExpression><![CDATA["pidm"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_GWid" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="40" y="0" width="45" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="ec82ec62-de29-45cc-900a-c1891bf8c3c0"/>    <textFieldExpression><![CDATA["GWid"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_Full Name" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="85" y="0" width="85" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="6a15c889-82f1-40c5-b6e6-11b1bf78d5d4"/>    <textFieldExpression><![CDATA["Full Name"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_Detail code" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="170" y="0" width="36" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="39b43535-b91d-49cc-bd43-9474ab41a8be"/>    <textFieldExpression><![CDATA["Detail code"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_tier" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="206" y="0" width="35" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="24d228c7-5d68-40b3-9675-f6600ffb6be0"/>    <textFieldExpression><![CDATA["tier"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_Term code" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="241" y="0" width="47" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="542f0231-2248-4240-99ca-1b6ff81cd09c"/>    <textFieldExpression><![CDATA["Term code"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_Fee Amount" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="288" y="0" width="69" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="9040f0b9-e889-46d4-a54a-7032d609bf3d"/>    <textFieldExpression><![CDATA["Fee Amount"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_Course#" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="357" y="0" width="33" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="32009470-e1a8-4177-8e1d-ce6c77369d4b"/>    <textFieldExpression><![CDATA["Course#"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_College" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="390" y="0" width="83" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="323f582c-32ea-45fb-b816-c7a378779037"/>    <textFieldExpression><![CDATA["College"]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement key="header_Tuition Amount" positionType="Float" stretchType="RelativeToTallestObject" mode="Opaque" x="473" y="0" width="82" height="30" isPrintWhenDetailOverflows="true" backcolor="#F0EDED" uuid="e8de798d-2a92-404d-bf48-97d995950858"/>    <textFieldExpression><![CDATA["Tuition Amount"]]></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="40" height="15" isPrintWhenDetailOverflows="true" uuid="2bedf49a-348f-4055-9573-16b8617af51d"/>    <textFieldExpression><![CDATA[$F{pidm}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="40" y="0" width="45" height="15" isPrintWhenDetailOverflows="true" uuid="affb27ee-9913-42f4-988f-c98383d92da1"/>    <textFieldExpression><![CDATA[$F{GWid}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="85" y="0" width="85" height="15" isPrintWhenDetailOverflows="true" uuid="8fa75214-8a2c-4cef-bff6-3d94abf13b9b"/>    <textFieldExpression><![CDATA[$F{Full Name}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="170" y="0" width="36" height="15" isPrintWhenDetailOverflows="true" uuid="8f1287ee-9d6d-4609-8d81-16bce0d19b30"/>    <textFieldExpression><![CDATA[$F{Detail code}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="206" y="0" width="35" height="15" isPrintWhenDetailOverflows="true" uuid="c1d83694-98b8-44df-b4d3-7263a38fd163"/>    <textFieldExpression><![CDATA[$F{tier}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="241" y="0" width="47" height="15" isPrintWhenDetailOverflows="true" uuid="45e233c3-e991-43a1-940a-46e5eac5fd92"/>    <textFieldExpression><![CDATA[$F{Term code}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" pattern="$ 0.00" isBlankWhenNull="true">    <reportElement key="" positionType="Float" stretchType="RelativeToTallestObject" x="288" y="0" width="69" height="15" isPrintWhenDetailOverflows="true" uuid="d806d7c1-72e2-469e-ba70-28646d53a800"/>    <textFieldExpression><![CDATA[$F{Fee Amount}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="357" y="0" width="33" height="15" isPrintWhenDetailOverflows="true" uuid="aa19acac-d91e-4013-9534-c2a2efec274b"/>    <textFieldExpression><![CDATA[$F{Course#}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="390" y="0" width="83" height="15" isPrintWhenDetailOverflows="true" uuid="52179174-09c4-4ed3-8db0-d837d81f9272"/>    <textFieldExpression><![CDATA[$F{College}]]></textFieldExpression>   </textField>   <textField isStretchWithOverflow="true" pattern="$ 0.00" isBlankWhenNull="true">    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="473" y="0" width="82" height="15" isPrintWhenDetailOverflows="true" uuid="f5ce9b98-61bd-45cc-a52f-2bd70ae2a399"/>    <textFieldExpression><![CDATA[$F{Tuition Amount}]]></textFieldExpression>   </textField>  </band> </detail> <summary>  <band height="67" splitType="Stretch">   <staticText>    <reportElement x="348" y="7" width="100" height="20" uuid="889975eb-661b-46a6-be5e-6d200a97ffca"/>    <text><![CDATA[Report Count]]></text>   </staticText>   <textField>    <reportElement x="450" y="7" width="100" height="20" uuid="affa24cb-6e3f-4a09-9b8c-2c8fa1a30750"/>    <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>   </textField>  </band> </summary></jasperReport>[/code]