且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

贾斯珀(Jasper),“打印时"创建空白,

更新时间:2023-09-21 08:48:04

我找到了解决方案,我只打印一次图表,但是每次都打印明细区域,所以我不得不移动print when表达式进入详细信息"乐队.

I found the solution, I was printing the chart only once, but I was printing the Detail band each time, so I had to move the print when expression to the Detail band.

<band height="160">
    <printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>

主图表必须具有垂直顺序的两列,以及子报表2的水平顺序.

The main chart must have two column in vertical order, and the subreport 2 column in horizontal order.

您还可以更改主要报表属性:
Print Order ==> verticalColumn Count ==> 2


You can also change the main report properties :
Print Order ==> vertical and Column Count ==> 2


***Example.jrxml:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.8.0.final using JasperReports Library version 6.8.0-2ed8dfabb690ff337a5797129f2cd92902b0c87b  -->
<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="***Example" columnCount="2" pageWidth="595" pageHeight="842" columnWidth="277" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="749cd048-9a0d-4a00-89bf-1a75a4565943">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/>
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <queryString>
        <![CDATA[SELECT  "ORDERS"."SHIPCOUNTRY", 
    Max("ORDERS"."SHIPCOUNTRY") 
FROM  "ORDERS"

GROUP BY "ORDERS"."SHIPCOUNTRY" 
ORDER BY "ORDERS"."SHIPCOUNTRY" ASC]]>
    </queryString>
    <field name="SHIPCOUNTRY" class="java.lang.String">
        <property name="com.jaspersoft.studio.field.label" value="SHIPCOUNTRY"/>
        <property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
    </field>
    <field name="C2" class="java.lang.String">
        <property name="com.jaspersoft.studio.field.label" value="C2"/>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <detail>
        <band height="170">
            <subreport>
                <reportElement x="-20" y="50" width="297" height="120" isRemoveLineWhenBlank="true" uuid="4b89b974-f838-4bb7-85b6-1b0f1079c1e6">
                    <property name="com.jaspersoft.studio.unit.width" value="px"/>
                </reportElement>
                <subreportParameter name="country">
                    <subreportParameterExpression><![CDATA[$F{SHIPCOUNTRY}]]></subreportParameterExpression>
                </subreportParameter>
                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                <subreportExpression><![CDATA["***ExampleSubReport.jasper"]]></subreportExpression>
            </subreport>
            <textField>
                <reportElement x="43" y="0" width="185" height="50" uuid="0c170024-70ea-492f-95fe-99ff3a27cb6d"/>
                <textElement textAlignment="Center" verticalAlignment="Middle">
                    <font size="19"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{SHIPCOUNTRY}]]></textFieldExpression>
            </textField>
        </band>
    </detail>
</jasperReport>


***ExampleSubReport.jrxml:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.8.0.final using JasperReports Library version 6.8.0-2ed8dfabb690ff337a5797129f2cd92902b0c87b  -->
<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="***Example" columnCount="2" printOrder="Horizontal" pageWidth="595" pageHeight="842" columnWidth="277" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="749cd048-9a0d-4a00-89bf-1a75a4565943">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/>
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <parameter name="country" class="java.lang.String">
        <defaultValueExpression><![CDATA["France"]]></defaultValueExpression>
    </parameter>
    <queryString>
        <![CDATA[SELECT "ORDERS"."ORDERDATE",
    "ORDERS"."FREIGHT"
FROM "ORDERS"
WHERE  "ORDERS"."SHIPCOUNTRY" = $P{country}]]>
    </queryString>
    <field name="ORDERDATE" class="java.sql.Timestamp">
        <property name="com.jaspersoft.studio.field.label" value="ORDERDATE"/>
        <property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
    </field>
    <field name="FREIGHT" class="java.math.BigDecimal">
        <property name="com.jaspersoft.studio.field.label" value="FREIGHT"/>
        <property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <detail>
        <band height="130">
            <printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==1)]]></printWhenExpression>
            <lineChart>
                <chart evaluationTime="Report">
                    <reportElement isPrintRepeatedValues="false" x="0" y="3" width="235" height="125" isRemoveLineWhenBlank="true" uuid="3b5f7d89-490b-468f-9112-f606f4eda437"/>
                    <chartTitle/>
                    <chartSubtitle/>
                    <chartLegend/>
                </chart>
                <categoryDataset>
                    <categorySeries>
                        <seriesExpression><![CDATA[$P{country}]]></seriesExpression>
                        <categoryExpression><![CDATA[$F{ORDERDATE}]]></categoryExpression>
                        <valueExpression><![CDATA[$F{FREIGHT}]]></valueExpression>
                    </categorySeries>
                </categoryDataset>
                <linePlot>
                    <plot/>
                    <categoryAxisFormat>
                        <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/>
                    </categoryAxisFormat>
                    <valueAxisFormat>
                        <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/>
                    </valueAxisFormat>
                </linePlot>
            </lineChart>
        </band>
    </detail>
</jasperReport>