How to create multiple tables in jasper report using json as a datasource?

by

The structure will be

  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

This is the result

PDF Result

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.

Main report

<?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>

Subreport in detail band 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>

Subreport in summary band 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>

More Related Contents:

  1. Create REST API without using any backend
  2. Go JSON Naming strategy about extends
  3. Does JSON syntax allow duplicate keys in an object?
  4. How do I initialize a TypeScript Object with a JSON-Object?
  5. How to escape double quotes in JSON
  6. Swift 4 Decodable with keys not known until decoding time
  7. Using codable with value that is sometimes an Int and other times a String
  8. How to parse/deserialize dynamic JSON
  9. What are the differences between application/json and application/x-www-form-urlencoded?
  10. With JSONDecoder in Swift 4, can missing keys use a default value instead of having to be optional properties?
  11. Elasticsearch Bulk Index JSON Data
  12. Add JSON serializer to every model class?
  13. How do I send a JSON string in a POST request in Go
  14. How to parse a JSON object to a TypeScript Object
  15. Can JSON numbers be quoted?
  16. jq: print key and value for each entry in an object
  17. How do I `jsonify` a list in Flask? [duplicate]
  18. Mapping JSON data in JQGrid
  19. Parsing multiple JSON objects in Go
  20. Is it possible to partially decode and update JSON? (go)
  21. OpenAPI path/query parameters nested structure serialization
  22. Decoding Error — Expected to decode Dictionary but found an array instead
  23. Can I encrypt my JSON data?
  24. Reading JSON with Apache Spark – `corrupt_record`
  25. How to parse JSON from the Invoke-WebRequest in PowerShell?
  26. AngularJS Intercept all $http JSON responses
  27. How to escape single quotes into double quotes into single quotes
  28. How to convert a JSON file to an SQLite database
  29. Any when decoding JSON with Codable?
  30. Using VBA and VBA-JSON to access JSON data from WordPress API

Leave a Comment