create table from nested json object

[phj0001]

Hello experts,

I want to create below table from the json datasource in jasper studio

Name of Scheme(s)	Type of Transfer-in Accounts	Number of business days								Total
		1	2	3	4	5	6	7	>7
HSBC Mandatory Provident Fund - SuperTrust	PA	45	21	133	234	2	0	0	0	435
	EE CON + SEP	43	35	99	164	1	0	0	0	342
HSBC Mandatory Provident Fund - SuperTrust Plus	PA	209	82	329	491	4	4	0	0	1119
	EE CON + SEP	149	51	269	379	2	0	0	0	850
HSBC Mandatory Provident Fund - SimpleChoice	PA	0	0	6	6	0	0	0	0	12
	EE CON + SEP	0	0	0	0	0	0	0	0	0

i have created json datasource first , then created dataset but i am unable to bind that datasource with the table properly

i have created json file like below, let me know if it is not correct:

JSON:

  {

    "name of schema(s)": [{"HSBC mandatory fund":[{

    "type of transfer-in accounts": "PA",

    "number of business days": [

      {

        "1": 45,

        "2": 21,

"3": 133,

"4": 234,

"5": 2,

"6": 0,

"7": 0,

">7": 0

      }

    ],

    "Total": 435},

{

    "type of transfer-in accounts": "EE CON + SEP",

    "number of business days": [

      {

        "1": 43,

        "2": 35,

"3": 99,

"4": 164,

"5": 1,

"6": 0,

"7": 0,

">7": 0

      }

    ],

    "Total": 342}

]

  }

 ]

}

 

please help me out with how to create that table in jasper studio

i want jrxml file of that table and want it to use somewhere else

 

thanks in advance:)