如何使用json作为数据源在jasper报表中创建多个表？ [英] How to create multiple tables in jasper report using json as a datasource?

查看：372
本文介绍了如何使用json作为数据源在jasper报表中创建多个表？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我需要像这样报告：

Product Name : Product XYZ

---------------------------------
| Item Name | Quantity | Price |
---------------------------------
| Item ABC  | 10       | 10 $  |
| Item BCD  | 10       | 1  $  |

Product Name : Product XYZ2

---------------------------------
| Item Name | Quantity | Price |
---------------------------------
| Item DEF  | 15       | 10 $  |
| Item HIJ  | 11       | 1  $  |

Summary Report 
---------------------------------
| Product Name | Total Quantity | 
---------------------------------
| Product XYZ  | 20             | 
| Product XYZ2 | 26             |

第一个问题是产品可以是1到多个。

The first problem is "product" can 1 to many.

第二个问题是我在底部需要摘要报告

The second problem is i need "Summary Report" in the bottom

第三个问题是，这个原始数据报告来自 json ，而不是从查询到数据库。

The third problem is ,this raw data report come from json, not from query to database.

我已经尝试了什么：


  • 为产品创建许多表。但这失败了因为jasper为未使用的表创建了空白空间。其他页面中的摘要表有很多空格。

  • Create many table for product. But this failed because jasper create empty space for unused table. And the summary table in other page with many empty space.

子报表，与上面相同。

请告诉我，如何动态制作多张桌子？

Can you tell me please, how to make dynamically multiple table's?

编辑：示例JSON 

{"produkList": {
"items":[ 
    {
        "nameProduct": "Product XYZ",
        "itemList": [{
            "itemName": "XXXXXXX",
            "quantity": 50,
            "price": 50
        },
        {
            "itemName": "YYYYYYY",
            "quantity": 50,
            "price": 50
        },
        {
            "itemName": "ZZZZZZZZ",
            "quantity": 50,
            "price": 50
        }]
    },
    {
        "nameProduct": "Product XYZ2",
        "itemList": [{
            "itemName": "AAAAAAAA",
            "quantity": 50,
            "price": 50
        },
        {
            "itemName": "BBBBBBB",
            "quantity": 50,
            "price": 50
        },
        {
            "itemName": "CCCCCCC",
            "quantity": 50,
            "price": 50
        }]
    }
  ],
  "summary":[
  {
        "title": "Summary Report",
        "summaryReportDetailList": [{
            "nameProduct": "Product XYZ",
            "quantity": 150
        },
        {
            "nameProduct": "Product XYZ2",
            "quantity": 150
        }]
    }
    ]
  }
}


推荐答案

结构将是


  1. 带查询的主报告 produkList.items 显示的产品名称

  2. 详细信息中的子报告带< dataSourceExpression>的带<！[CDATA [（（net.sf.jasperreports.eng ine.data.JsonDataSource）$ P {REPORT_DATA_SOURCE}）。subDataSource（itemList）]]>< / dataSourceExpression> 显示项目表

  3. 汇总带有查询 produkList.summary.summaryReportDetailList 的子报告显示汇总表

  1. Main report with query produkList.items that display's Product Name
  2. Subreport in detail band with <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("itemList")]]></dataSourceExpression> to display the item table
  3. Subreport in summary band with query produkList.summary.summaryReportDetailList to display the summary table

这是结果

下面你会发现3 jrxml产生这个结果，你需要调整json的路径子报表的源和路径，不要忘记在运行主报表之前需要在 .jasper 中编译子报表。

Below you will find the 3 jrxml producing this result, you need to adjust the path to the json source and path to subreport's, don't forget that subreport's need to be compiled in .jasper before main report can be run.

主要报告 

<?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="multitable" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1c6dc1c9-67af-43d5-bf1e-9243557c8048">
<property name="net.sf.jasperreports.json.source" value="C:/jdd/projects/StackTrace/jasper/multitable.json"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
    <defaultValueExpression><![CDATA["C:\\jdd\\projects\\StackTrace\\jasper\\"]]></defaultValueExpression>
</parameter>
<queryString language="json">
    <![CDATA[produkList.items]]>
</queryString>
<field name="nameProduct" class="java.lang.String"/>
<detail>
    <band height="48" splitType="Stretch">
        <textField>
            <reportElement x="0" y="1" width="555" height="20" uuid="4dfdf5e5-436e-4538-b302-620ea945c6e7"/>
            <textElement verticalAlignment="Middle"/>
            <textFieldExpression><![CDATA["Product Name : " + $F{nameProduct}]]></textFieldExpression>
        </textField>
        <subreport>
            <reportElement x="0" y="21" width="555" height="20" uuid="48a7bbe4-b8ce-4a0d-a6e1-6ddd288e5602"/>
            <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("itemList")]]></dataSourceExpression>
            <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "multitable_subreport.jasper"]]></subreportExpression>
        </subreport>
    </band>
</detail>
<summary>
    <band height="52" splitType="Stretch">
        <subreport>
            <reportElement x="0" y="10" width="555" height="32" uuid="780a1f25-065e-494a-ba1d-86a33b464343"/>
            <subreportParameter name="net.sf.jasperreports.json.source">
                <subreportParameterExpression><![CDATA["C:/jdd/projects/StackTrace/jasper/multitable.json"]]></subreportParameterExpression>
            </subreportParameter>
            <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "multitable_summary.jasper"]]></subreportExpression>
        </subreport>
    </band>
</summary>
</jasperReport>

详细信息带子报告 multitable_subreport.jrxml 

<?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="multitable_subreport" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="678bf408-397f-4797-bb50-84262b9df76b">
<field name="itemName" class="java.lang.String"/>
<field name="quantity" class="java.lang.Double"/>
<field name="price" class="java.lang.Double"/>
<columnHeader>
    <band height="20" splitType="Stretch">
        <staticText>
            <reportElement mode="Opaque" x="0" y="0" width="100" height="20" backcolor="#CCCCCC" uuid="af654b95-0a60-40fc-80c6-df38cc28061c"/>
            <box>
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement verticalAlignment="Middle"/>
            <text><![CDATA[itemName]]></text>
        </staticText>
        <staticText>
            <reportElement mode="Opaque" x="100" y="0" width="100" height="20" backcolor="#CCCCCC" uuid="7969463f-0569-4863-bbc3-a87364369a0f"/>
            <box>
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement textAlignment="Center" verticalAlignment="Middle"/>
            <text><![CDATA[quantity]]></text>
        </staticText>
        <staticText>
            <reportElement mode="Opaque" x="200" y="0" width="100" height="20" backcolor="#CCCCCC" uuid="86942d20-9a68-4409-8907-8abcfef1c82e"/>
            <box>
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement textAlignment="Center" verticalAlignment="Middle"/>
            <text><![CDATA[price]]></text>
        </staticText>
    </band>
</columnHeader>
<detail>
    <band height="20" splitType="Stretch">
        <textField>
            <reportElement x="0" y="0" width="100" height="20" uuid="2b991eb1-6e24-4e74-8ee2-cd90fe07f60a"/>
            <box>
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement verticalAlignment="Middle"/>
            <textFieldExpression><![CDATA[$F{itemName}]]></textFieldExpression>
        </textField>
        <textField pattern="###0.##">
            <reportElement x="100" y="0" width="100" height="20" uuid="71929061-2351-477c-8d2d-431c846f8a06"/>
            <box>
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement textAlignment="Center" verticalAlignment="Middle"/>
            <textFieldExpression><![CDATA[$F{quantity}]]></textFieldExpression>
        </textField>
        <textField pattern="¤ #,##0.00">
            <reportElement x="200" y="0" width="100" height="20" uuid="16b99246-d1f5-4c96-90db-34ea5f3141db"/>
            <box>
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement textAlignment="Center" verticalAlignment="Middle"/>
            <textFieldExpression><![CDATA[$F{price}]]></textFieldExpression>
        </textField>
    </band>
</detail>
</jasperReport>

摘要带中的子报告 multitable_summary.jrxml 

<?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="multitable_summary" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="2a869c20-1e7d-4baa-92d7-c8d555f1f344">
<queryString language="json">
    <![CDATA[produkList.summary.summaryReportDetailList]]>
</queryString>
<field name="nameProduct" class="java.lang.String"/>
<field name="quantity" class="java.lang.Double"/>
<background>
    <band splitType="Stretch"/>
</background>
<title>
    <band height="23">
        <staticText>
            <reportElement x="0" y="0" width="100" height="20" uuid="a9730039-8418-4e58-a2eb-0babe8d2a380"/>
            <text><![CDATA[Summary Report]]></text>
        </staticText>
    </band>
</title>
<columnHeader>
    <band height="20">
        <staticText>
            <reportElement mode="Opaque" x="0" y="0" width="100" height="20" backcolor="#CCCCCC" uuid="a49b18ef-63c3-42bb-ae81-8d7d72ac9086"/>
            <box leftPadding="0">
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement verticalAlignment="Middle"/>
            <text><![CDATA[Product Name]]></text>
        </staticText>
        <staticText>
            <reportElement mode="Opaque" x="100" y="0" width="100" height="20" backcolor="#CCCCCC" uuid="c1c70fed-d887-429f-a3b0-ed645517e41f"/>
            <box leftPadding="0">
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement textAlignment="Center" verticalAlignment="Middle"/>
            <text><![CDATA[quantity]]></text>
        </staticText>
    </band>
</columnHeader>
<detail>
    <band height="20" splitType="Stretch">
        <textField>
            <reportElement x="0" y="0" width="100" height="20" uuid="401436b3-d9a1-40bd-8a1d-dfa3f162f842"/>
            <box leftPadding="0">
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement verticalAlignment="Middle"/>
            <textFieldExpression><![CDATA[$F{nameProduct}]]></textFieldExpression>
        </textField>
        <textField pattern="###0">
            <reportElement x="100" y="0" width="100" height="20" uuid="4447d3b0-6d3e-4795-8b5f-6a09d620448b"/>
            <box leftPadding="0">
                <pen lineWidth="0.25"/>
                <topPen lineWidth="0.25"/>
                <leftPen lineWidth="0.25"/>
                <bottomPen lineWidth="0.25"/>
                <rightPen lineWidth="0.25"/>
            </box>
            <textElement textAlignment="Center" verticalAlignment="Middle"/>
            <textFieldExpression><![CDATA[$F{quantity}]]></textFieldExpression>
        </textField>
    </band>
</detail>
</jasperReport>

这篇关于如何使用json作为数据源在jasper报表中创建多个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆