Jasper Reports中的CSV格式 [英] CSV formatting in Jasper Reports

问题描述

我正在将我创建的报告导出到CSV文件。导出正常，但格式化已关闭，我在文本字段中显示的变量根本不显示。

I am exporting a report I created to a CSV file. The export goes fine but the formatting is off and the variable that I have displaying in a text field doesn't show up at all.

格式化不对齐列正确并且它正在重新调整它们的大小，以便除非您展开列，否则不会显示这些值。此外，显示我的变量$ V {r​​eportTotal}的文本字段设置为BigDecimal并格式化为货币。此文本字段不显示任何内容。

The formatting isn't aligning columns properly and it's re-sizing them so that the values don't show up unless you expand the column. Also, the text field displaying my variable $V{reportTotal} is set as a BigDecimal and formatted for currency. This text field doesn't show anything.

当我选择PDF输出时，一切看起来都很棒。如何解决CSV输出的这些格式问题？

Everything looks great when I choose PDF output. What can I do to fix these formatting problems for CSV output?

推荐答案

您可以尝试以下示例：

<jasperReport ...>
        ...
    <field name="ORDERS_ORDERID" class="java.lang.Integer"/>
    <field name="ORDERS_CUSTOMERID" class="java.lang.String"/>
    <field name="ORDERS_FREIGHT" class="java.math.BigDecimal"/>
        ...
    <detail>
        <band height="20" splitType="Stretch">
            <textField>
                <reportElement x="0" y="0" width="100" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[$F{ORDERS_FREIGHT}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="100" y="0" width="100" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[$F{ORDERS_ORDERID}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="200" y="0" width="100" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[$F{ORDERS_CUSTOMERID}]]></textFieldExpression>
            </textField>
        </band>
    </detail>
</jasperReport>

结果是：

32.38,10248，VINET

11.61,10249，TOMSP

65.83,10250，HANAR

41.34,10251，VICTE

51.3,10252，SUPRD

55.09,10260，OTTIK

3.05,10261，QUEDE

48.29,10262， RATTC

32.38,10248,VINET
11.61,10249,TOMSP
65.83,10250,HANAR
41.34,10251,VICTE
51.3,10252,SUPRD
55.09,10260,OTTIK
3.05,10261,QUEDE
48.29,10262,RATTC

我认为你应该检查你的结果 csv 文件在基本文本查看器/编辑器中（例如，Windows上的Notepad ++或Notepad）。

I think you should check your result csv file in basic text viewer/editor (for example, Notepad++ or Notepad on Windows).

这篇关于Jasper Reports中的CSV格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！