{"name": "CUSTOM-EHP-REPORT-AI-ทะเบียนยาที่เปิดใช้งาน", "title": "ทะเบียนยาที่เปิดใช้งาน", "landscape": false, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.unitcost AS unit_cost, drugitems.units AS unit\nFROM drugitems\nWHERE drugitems.istatus = 'Y'\nORDER BY drugitems.name"}], "columns": [{"field": "icode", "caption": "รหัสยา", "format": null, "memo": false, "align": "taLeftJustified", "width": 18.0}, {"field": "drug_name", "caption": "ชื่อยา", "format": null, "memo": true, "align": "taLeftJustified"}, {"field": "strength", "caption": "ความแรง", "format": null, "memo": false, "align": "taLeftJustified", "width": 30.0}, {"field": "dosageform", "caption": "รูปแบบยา", "format": null, "memo": false, "align": "taLeftJustified", "width": 35.0}, {"field": "unit_cost", "caption": "ราคาทุน", "format": "#,0.00", "memo": false, "align": "taLeftJustified", "width": 18.0}, {"field": "unit", "caption": "หน่วยนับ", "format": null, "memo": false, "align": "taLeftJustified", "width": 18.0}], "highlight": []}