Jasper之table报表

最新推荐文章于 2024-07-01 17:26:55 发布

weixin_33788244

最新推荐文章于 2024-07-01 17:26:55 发布

阅读量646

点赞数 1

文章标签： java json 数据结构与算法

原文链接：http://www.cnblogs.com/AmbitiousMice/p/7793623.html

版权

本文介绍了如何直接操作Jasper报表的XML源码来创建表格，无需依赖IDE。通过详细讲解配置数据源、参数和表格字段，展示了在XML中设置table的方法，适合已熟悉Jasper报表的开发者参考。

摘要由CSDN通过智能技术生成

这段时间用Jasper画报表，讲真的Jasper IDE真的很难用，网上找很久都没找到用table画的配置方法，以下是直接操作源码画table的方法，不用IDE一样可以做出来（不过样式还是得借助IDE拖拽调整容易些），以下是简要介绍，如果你对Jasper比较熟悉，只需得知table数据源的配置方式可以跳过前面的直接看table设置：

<?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="CC_RESULT_INV" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5d4aa9eb-83ee-4f4d-a663-80ec6888dacb">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="iwms\inner\dataAdapter\count_result_inv.xml"/>（配置适配器）
<property name="net.sf.jasperreports.print.create.bookmarks" value="false"/>
<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_CH" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="count_result_inv" uuid="86287dda-f4b9-4a82-ad21-41fe0aa75034">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="iwms\inner\dataAdapter\count_result_inv.xml"/>（数据源配置以下的field是table里的参数）
<field name="num" class="java.lang.Integer">
<property name="net.sf.jasperreports.json.field.expression" value="num"/>
<fieldDescription><![CDATA[num]]></fieldDescription>
</field>
<field name="ownerCode" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="ownerCode"/>
<fieldDescription><![CDATA[ownerCode]]></fieldDescription>
</field>
<field name="ownerName" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="ownerName"/>
<fieldDescription><![CDATA[ownerName]]></fieldDescription>
</field>
<field name="barcode" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="barcode"/>
<fieldDescription><![CDATA[barcode]]></fieldDescription>
</field>
<field name="skuName" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="skuName"/>
<fieldDescription><![CDATA[skuName]]></fieldDescription>
</field>
<field name="size" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="size"/>
<fieldDescription><![CDATA[size]]></fieldDescription>
</field>
<field name="color" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="color"/>
<fieldDescription><![CDATA[color]]></fieldDescription>
</field>
<field name="styleNum" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="styleNum"/>
<fieldDescription><![CDATA[styleNum]]></fieldDescription>
</field>
<field name="brand" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="brand"/>
<fieldDescription><![CDATA[brand]]></fieldDescription>
</field>
<field name="lot" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="lot"/>
<fieldDescription><![CDATA[lot]]></fieldDescription>
</field>
<field name="loc" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="loc"/>
<fieldDescription><![CDATA[loc]]></fieldDescription>
</field>
<field name="lpn" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="lpn"/>
<fieldDescription><![CDATA[lpn]]></fieldDescription>
</field>
<field name="caseNum" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="caseNum"/>
<fieldDescription><![CDATA[caseNum]]></fieldDescription>
</field>
<field name="systemQty" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="systemQty"/>
<fieldDescription><![CDATA[systemQty]]></fieldDescription>
</field>
<field name="qty" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="qty"/>
<fieldDescription><![CDATA[qty]]></fieldDescription>
</field>
<field name="diffQty" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="diffQty"/>
<fieldDescription><![CDATA[diffQty]]></fieldDescription>
</field>
<field name="countTime" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="countTime"/>
<fieldDescription><![CDATA[countTime]]></fieldDescription>
</field>
</subDataset>
<parameter name="tenantId" class="java.lang.Long">（parameter 是获取报表需要的参数）
<parameterDescription><![CDATA[租户ID]]></parameterDescription>
</parameter>
<parameter name="warehouseCode" class="java.lang.String">
<parameterDescription><![CDATA[仓库编码]]></parameterDescription>
</parameter>
<parameter name="countNum" class="java.lang.String">
<parameterDescription><![CDATA[盘点单号]]></parameterDescription>
</parameter>
<parameter name="operatorId" class="java.lang.Long">
<parameterDescription><![CDATA[制单人ID]]></parameterDescription>
</parameter>