How to Read JSON Data to Table



  • I have the JSON Data as in the example and want to create a table like the picture. I Experiment Create the loop . But it doesn't work. There is an error. Ask for your idea and code examples. How can I convert the data?

    Now...
    0_1566817795294_1.jpg

    Required
    0_1566818120985_3.jpg
    0_1566818127960_2.jpg

    Exam Data
    Code
    {
    "count": 17,
    "StartDate" : "2019-08-23",
    "rows": [
    {
    "SEQ": 28,
    "PARTNER": "ไพรวัลย์ อัปติกานัง",
    "META": [
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 8.1795
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.2021
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.258
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.0903
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.4602
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.4043
    }
    ]
    },
    {
    "SEQ": 39,
    "PARTNER": "อำพร ประศรีหาคลัง",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.281
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.6532
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 13.1954
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.3233
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 9.4988
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.3314
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 6.712
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.9828
    }
    ]
    },
    {
    "SEQ": 40,
    "PARTNER": "วิลัยจิต วงษ์จันทึก",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Diesel",
    "QTY": 9.8307
    },
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 22.4449
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.6213
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 27.118
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Diesel",
    "QTY": 29.4957
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 18.5379
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Diesel",
    "QTY": 6.5538
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 6.5447
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.6213
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 14.3346
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Diesel",
    "QTY": 16.3857
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 11.2576
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Diesel",
    "QTY": 13.1088
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 16.8314
    }
    ]
    },
    {
    "SEQ": 41,
    "PARTNER": "วิลัยจิต วงษ์จันทึก",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 28.425
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.2767
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 27.9299
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.2933
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 27.9903
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 15.2542
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Diesel",
    "QTY": 6.5534
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 27.1182
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 47.0735
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Diesel",
    "QTY": 6.5534
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 16.4569
    }
    ]
    },
    {
    "SEQ": 56,
    "PARTNER": "สุทธิ ศรีบัวระบาล",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.2136
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.5252
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.9535
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.0506
    }
    ]
    },
    {
    "SEQ": 58,
    "PARTNER": "สงวนศิลป์ ภูมิศักดิ์",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Diesel",
    "QTY": 1.9975
    },
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 10.1198
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 9.6905
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.9514
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.1255
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Diesel",
    "QTY": 0.7458
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.5696
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Diesel",
    "QTY": 0.5961
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 13.1119
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 6.6962
    }
    ]
    },
    {
    "SEQ": 59,
    "PARTNER": "เรืองศิลป์ ปินะกาโน",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.2389
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.6896
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.278
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.1034
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.7586
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.3448
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.8654
    }
    ]
    },
    {
    "SEQ": 61,
    "PARTNER": "สุรพงษ์ เผิ่งจันดา",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.7022
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 0.5963
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.5641
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.7022
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.984
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 6.842
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.8495
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Diesel",
    "QTY": 5.968
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 9.9773
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 6.7895
    }
    ]
    },
    {
    "SEQ": 63,
    "PARTNER": "ทิพย์รัตน์ เดชนิติรัตน์",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.7494
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.1672
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.5326
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.9185
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.8476
    }
    ]
    },
    {
    "SEQ": 64,
    "PARTNER": "ทิพย์รัตน์ เดชนิติรัตน์",
    "META": [
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.9497
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.9497
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.6334
    }
    ]
    },
    {
    "SEQ": 71,
    "PARTNER": "บุญเพ็ง มาลา",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.2611
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.1724
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.2087
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.285
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.4885
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.6043
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.813
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.6021
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 6.3485
    }
    ]
    },
    {
    "SEQ": 74,
    "PARTNER": "สำรวย พุดสี",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.9829
    },
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.4119
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 5.9671
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.983
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 9.0344
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Diesel",
    "QTY": 4.1763
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.778
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.9829
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.1809
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 9.8317
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.9829
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 8.548
    }
    ]
    },
    {
    "SEQ": 75,
    "PARTNER": "รัชนี เตชะแก้ว",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.6049
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 6.3248
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.8024
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.5533
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Diesel",
    "QTY": 0.6315
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.707
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.1624
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.9033
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.6552
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Diesel",
    "QTY": 1.8969
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.2073
    }
    ]
    },
    {
    "SEQ": 76,
    "PARTNER": "สุรัตน์ ธรรมพล",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.2801
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 6.1506
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.1081
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.0753
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 10.6789
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Diesel",
    "QTY": 9.2271
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.2556
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 4.9876
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 14.0807
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.5865
    }
    ]
    },
    {
    "SEQ": 104,
    "PARTNER": "นิศมา แสนศรี",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 17.6485
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Diesel",
    "QTY": 3.2242
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 18.1098
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Diesel",
    "QTY": 4.514
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 24.2504
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Diesel",
    "QTY": 5.8036
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 24.8009
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Diesel",
    "QTY": 2.5794
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 14.1583
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Diesel",
    "QTY": 14.8314
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 17.7627
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Diesel",
    "QTY": 7.738
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 21.5598
    }
    ]
    },
    {
    "SEQ": 105,
    "PARTNER": "โรงเรียนนาข่าวิทยา จ.มหาสารคาม",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.6013
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 5.6989
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.2658
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.6406
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.8986
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.482
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.9494
    }
    ]
    },
    {
    "SEQ": 153,
    "PARTNER": "ทรัพย์อนันต์ พิมพา",
    "META": [
    {
    "DATE": "2019-08-17",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 0.5663
    },
    {
    "DATE": "2019-08-18",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.7
    },
    {
    "DATE": "2019-08-19",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.6844
    },
    {
    "DATE": "2019-08-20",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 7.3701
    },
    {
    "DATE": "2019-08-21",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 3.9676
    },
    {
    "DATE": "2019-08-22",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 1.1337
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Diesel",
    "QTY": 5.9506
    },
    {
    "DATE": "2019-08-23",
    "FUEL_TYPE": "Gasohol 95",
    "QTY": 2.835
    }
    ]
    }
    ]
    }



  • This post is deleted!


  • This post is deleted!

  • administrators

    hi! you can create your example here , save it and then comment the link back here. if you want some guidance the best you can do is to create an example in playground, with that we can check the code and modify it to give you an idea what you need to do to meet your requirements



  • Thank you for you information. But do not help. I find good example that Playground and test. But not work. Because my data table the number of columns on rows is unequal and uneven.


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.