jsreport forum

santhapat

{{#each $pdf.pages}}
{{#if 0}}
<div style="page-break-before: always;"></div>
{{/if}}
<main class="main">
<header class="header">
{{#with (lookup ../$pdf.pages 0)}}
{{group}}
{{/with}}
</header>
<footer class="footer">
<table style="width: 100%;">
<tr><td style="width: 50%; font face:arial; font-size:12px;">Print Date {{getDate}}</td><td style="text-align: right; width: 50%; font face:arial; font-size:12px" >Page {{getPageNumber 0}} of {{getTotalPages ../$pdf.pages}}</td></tr>
</table>
</footer>
</main>
{{/each}}

santhapat

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.

santhapat

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

Required

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

santhapat

My Code
{{#if ROWS_NO = 1}}

{{/if}}
My Data
0_1563954264088_upload-2ca0c105-9ccd-4f60-948b-efa3b2cd40fa
Show Error
0_1563954274191_upload-bb7a54b5-48ce-48ea-abb4-56b7e0fbb0f9

Pls. help me

santhapat

I set rowspan when i get data show on report that show duplicate !
0_1562989775771_upload-5752fd3f-b1f1-4f58-89fd-61ca99ee53f1 image url)

santhapat

thank you sir now is ok when i adjust to: {{{getMeta H24}}}
( 0_1562829034229_upload-7bef19a7-e6f1-4735-9a9f-dbe3644adbac

santhapat

Why i set condition to css styles is not change. When i config is OK
![config css]( 0_1562746310520_upload-c0d9404b-db76-4a62-b961-d975987f160c url)

![Condition]( 0_1562746399175_upload-10d9e7e5-cc29-464f-b9a6-c2d8d8907e41 image url)

santhapat

@santhapat

Posts made by santhapat