{
  "version": "2.0",
  "page": {
    "width": 595,
    "height": 842,
    "marginTop": 32.0,
    "marginBottom": 32.0,
    "marginLeft": 32.0,
    "marginRight": 32.0
  },
  "pdf": {
    "title": "Customer Directory",
    "author": "FmxPdfTools",
    "subject": "Customers grouped by country",
    "keywords": "group;subtotal;count;directory",
    "creator": "FmxPdfTools"
  },
  "bands": [
    {
      "type": "Title",
      "height": 64.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Rectangle",
          "name": "",
          "left": 0.0,
          "top": 0.0,
          "width": 531.0,
          "height": 50.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#00000000",
          "fillColor": "#FF14233A",
          "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": "Image",
          "name": "",
          "left": 12.0,
          "top": 9.0,
          "width": 80.0,
          "height": 32.0,
          "text": "",
          "dataField": "",
          "imageFile": "logo.png",
          "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,
          "imageScale": "Fit"
        },
        {
          "type": "Label",
          "name": "",
          "left": 104.0,
          "top": 8.0,
          "width": 415.0,
          "height": 24.0,
          "text": "CUSTOMER DIRECTORY",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 18.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FFFFFFFF",
          "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": 104.0,
          "top": 30.0,
          "width": 415.0,
          "height": 16.0,
          "text": "Grouped by country",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FFEAF1F8",
          "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": "GroupHeader",
      "height": 30.0,
      "dataSource": "",
      "groupCondition": "Country",
      "elements": [
        {
          "type": "Rectangle",
          "name": "",
          "left": 0.0,
          "top": 4.0,
          "width": 531.0,
          "height": 22.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#00000000",
          "fillColor": "#FFFCEFD8",
          "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": "Rectangle",
          "name": "",
          "left": 0.0,
          "top": 4.0,
          "width": 5.0,
          "height": 22.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#00000000",
          "fillColor": "#FFE08A1E",
          "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": 6.0,
          "width": 411.0,
          "height": 18.0,
          "text": "[UPPER(Country)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 12.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": 421.0,
          "top": 6.0,
          "width": 102.0,
          "height": 18.0,
          "text": "Company",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": true,
          "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
        }
      ]
    },
    {
      "type": "MasterData",
      "height": 18.0,
      "dataSource": "customers",
      "groupCondition": "",
      "elements": [
        {
          "type": "Label",
          "name": "",
          "left": 4.0,
          "top": 1.0,
          "width": 28.0,
          "height": 15.0,
          "text": "[RecordNo]",
          "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": "Right",
          "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": 40.0,
          "top": 1.0,
          "width": 250.0,
          "height": 15.0,
          "text": "",
          "dataField": "CompanyName",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.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": 300.0,
          "top": 1.0,
          "width": 120.0,
          "height": 15.0,
          "text": "",
          "dataField": "City",
          "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": 424.0,
          "top": 1.0,
          "width": 107.0,
          "height": 15.0,
          "text": "",
          "dataField": "Phone",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.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
        },
        {
          "type": "Line",
          "name": "",
          "left": 40.0,
          "top": 16.0,
          "width": 491.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": 16.0
        }
      ]
    },
    {
      "type": "GroupFooter",
      "height": 26.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Line",
          "name": "",
          "left": 0.0,
          "top": 2.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": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 531.0,
          "y2": 2.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 12.0,
          "top": 6.0,
          "width": 507.0,
          "height": 16.0,
          "text": "[Country + ' subtotal:  ' + STR(COUNT()) + ' customers']",
          "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": "Summary",
      "height": 40.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "RoundRect",
          "name": "",
          "left": 0.0,
          "top": 6.0,
          "width": 531.0,
          "height": 28.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#00000000",
          "fillColor": "#FF1F4E79",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 0.0,
          "cornerX": 6.0,
          "cornerY": 6.0,
          "checked": false,
          "x2": 160.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 12.0,
          "top": 11.0,
          "width": 507.0,
          "height": 18.0,
          "text": "['GRAND TOTAL:  ' + STR(COUNT()) + ' customers']",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 12.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FFFFFFFF",
          "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": 0.0,
          "top": 5.0,
          "width": 200.0,
          "height": 14.0,
          "text": "FmxPdfTools",
          "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": "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": 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
        }
      ]
    }
  ]
}