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

Question

I need to make report like this:

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             |

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

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

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

What that i already try :

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.
Subreports , same like above.

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

EDIT : sample 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
        }]
    }
    ]
  }
}

Petter Friberg · Accepted Answer

The structure will be

Main report with query produkList.items that display's Product Name
Subreport in detail band with to display the item table
Subreport in summary band with query produkList.summary.summaryReportDetailList to display the summary table

This is the 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

Subreport in detail band multitable_subreport.jrxml

Subreport in summary band multitable_summary.jrxml




    




    


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

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

Answers (1)

Related Questions