{
  "version": "2.0",
  "page": {
    "width": 595,
    "height": 842,
    "marginTop": 32.0,
    "marginBottom": 32.0,
    "marginLeft": 32.0,
    "marginRight": 32.0
  },
  "pdf": {
    "title": "Account Statement",
    "author": "FmxPdfTools",
    "subject": "Three level master-detail",
    "keywords": "master-detail;subdetail;qualified field",
    "creator": "FmxPdfTools"
  },
  "bands": [
    {
      "type": "Title",
      "height": 54.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 4.0,
          "width": 531.0,
          "height": 26.0,
          "text": "ACCOUNT STATEMENT",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 20.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FF14233A",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 32.0,
          "width": 531.0,
          "height": 14.0,
          "text": "Customer / orders / line items",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Line",
          "name": "",
          "left": 0.0,
          "top": 50.0,
          "width": 531.0,
          "height": 0.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF1F4E79",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.5,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 531.0,
          "y2": 50.0
        }
      ]
    },
    {
      "type": "MasterData",
      "height": 70.0,
      "dataSource": "customers",
      "groupCondition": "",
      "elements": [
        {
          "type": "RoundRect",
          "name": "",
          "left": 0.0,
          "top": 4.0,
          "width": 531.0,
          "height": 58.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FFC9D2DC",
          "fillColor": "#FFEAF1F8",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 6.0,
          "cornerY": 6.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 12.0,
          "top": 10.0,
          "width": 331.0,
          "height": 18.0,
          "text": "",
          "dataField": "CompanyName",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 13.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FF14233A",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 12.0,
          "top": 30.0,
          "width": 331.0,
          "height": 14.0,
          "text": "[ContactName + '  -  ' + ContactTitle]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 12.0,
          "top": 44.0,
          "width": 331.0,
          "height": 14.0,
          "text": "[Address + '  -  ' + City + ' ' + Country]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Barcode",
          "name": "",
          "left": 355.0,
          "top": 12.0,
          "width": 168.0,
          "height": 40.0,
          "text": "[CustomerID]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Memo",
          "name": "",
          "left": 0.0,
          "top": 64.0,
          "width": 531.0,
          "height": 4.0,
          "text": "{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0 Segoe UI;}}{\\colortbl ;\\red31\\green78\\blue121;}\\f0\\fs15\\cf1\\b Account note:\\b0  balances are shown in the customer's shipping currency and exclude tax.\\par}",
          "dataField": "",
          "imageFile": "",
          "wordWrap": true,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        }
      ]
    },
    {
      "type": "DetailData",
      "height": 18.0,
      "dataSource": "orders",
      "groupCondition": "",
      "elements": [
        {
          "type": "Label",
          "name": "",
          "left": 12.0,
          "top": 1.0,
          "width": 120.0,
          "height": 15.0,
          "text": "['Order #' + STR(orders.OrderID)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FF222831",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 140.0,
          "top": 1.0,
          "width": 160.0,
          "height": 15.0,
          "text": "[FORMATDATETIME('dd MMM yyyy', orders.OrderDate)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 304.0,
          "top": 1.0,
          "width": 130.0,
          "height": 15.0,
          "text": "",
          "dataField": "ShipCity",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 435.0,
          "top": 1.0,
          "width": 88.0,
          "height": 15.0,
          "text": "[FORMAT('%.2f', orders.Freight)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF222831",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Right",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        }
      ]
    },
    {
      "type": "SubdetailData",
      "height": 15.0,
      "dataSource": "items",
      "groupCondition": "",
      "elements": [
        {
          "type": "Label",
          "name": "",
          "left": 32.0,
          "top": 0.0,
          "width": 16.0,
          "height": 13.0,
          "text": "-",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 48.0,
          "top": 0.0,
          "width": 280.0,
          "height": 13.0,
          "text": "",
          "dataField": "ProductName",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF222831",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 330.0,
          "top": 0.0,
          "width": 80.0,
          "height": 13.0,
          "text": "['x' + STR(Quantity)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 435.0,
          "top": 0.0,
          "width": 88.0,
          "height": 13.0,
          "text": "[FORMAT('%.2f', UnitPrice * Quantity)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF222831",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Right",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        }
      ]
    },
    {
      "type": "Summary",
      "height": 30.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Line",
          "name": "",
          "left": 0.0,
          "top": 4.0,
          "width": 531.0,
          "height": 0.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF14233A",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 531.0,
          "y2": 4.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 10.0,
          "width": 531.0,
          "height": 16.0,
          "text": "['Total orders listed: ' + STR(COUNT())]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FF1F4E79",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Right",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        }
      ]
    },
    {
      "type": "PageFooter",
      "height": 22.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Line",
          "name": "",
          "left": 0.0,
          "top": 0.0,
          "width": 531.0,
          "height": 0.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FFC9D2DC",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 0.5,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 531.0,
          "y2": 0.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 331.0,
          "top": 5.0,
          "width": 200.0,
          "height": 14.0,
          "text": "Page [PageNo] of [TotalPages]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 8.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF6B7480",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Right",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        }
      ]
    }
  ]
}