{
  "version": "2.0",
  "page": {
    "width": 595,
    "height": 842,
    "marginTop": 20.0,
    "marginBottom": 20.0,
    "marginLeft": 20.0,
    "marginRight": 20.0
  },
  "bands": [
    {
      "type": "PageHeader",
      "height": 50.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Rectangle",
          "name": "",
          "left": 0.0,
          "top": 0.0,
          "width": 555.0,
          "height": 38.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": "#FF1E3A8A",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 0.0,
          "cornerX": 4.0,
          "cornerY": 4.0,
          "checked": false,
          "x2": 555.0,
          "y2": 0.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 6.0,
          "width": 555.0,
          "height": 26.0,
          "text": "ORDER SUMMARY (Aggregate Demo)",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 14.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FFFFFFFF",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Center",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 555.0,
          "y2": 6.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 40.0,
          "width": 555.0,
          "height": 12.0,
          "text": "Page [PageNo] / [TotalPages]   -   [DateTime]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 8.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF808080",
          "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": 555.0,
          "y2": 40.0
        }
      ]
    },
    {
      "type": "GroupHeader",
      "height": 26.0,
      "dataSource": "",
      "groupCondition": "ShipCountry",
      "elements": [
        {
          "type": "Rectangle",
          "name": "",
          "left": 0.0,
          "top": 2.0,
          "width": 555.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": "#FFBFDBFE",
          "fillColor": "#FFEFF6FF",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 0.5,
          "cornerX": 4.0,
          "cornerY": 4.0,
          "checked": false,
          "x2": 555.0,
          "y2": 2.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 8.0,
          "top": 5.0,
          "width": 540.0,
          "height": 16.0,
          "text": "Country: [ShipCountry]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 11.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FF1E3A8A",
          "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": 548.0,
          "y2": 5.0
        }
      ]
    },
    {
      "type": "MasterData",
      "height": 18.0,
      "dataSource": "orders",
      "groupCondition": "",
      "elements": [
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 2.0,
          "width": 60.0,
          "height": 14.0,
          "text": "",
          "dataField": "OrderID",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.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": 60.0,
          "y2": 2.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 65.0,
          "top": 2.0,
          "width": 95.0,
          "height": 14.0,
          "text": "[FORMATDATETIME('dd.mm.yyyy',OrderDate)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF555555",
          "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": 2.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 310.0,
          "top": 2.0,
          "width": 131.0,
          "height": 14.0,
          "text": "",
          "dataField": "ShipName",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.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": 445.0,
          "y2": 2.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 450.0,
          "top": 2.0,
          "width": 100.0,
          "height": 14.0,
          "text": "[STR(ROUND(Freight,2))]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "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": 550.0,
          "y2": 2.0
        }
      ]
    },
    {
      "type": "GroupFooter",
      "height": 38.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Line",
          "name": "",
          "left": 0.0,
          "top": 2.0,
          "width": 100.0,
          "height": 20.0,
          "text": "",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF000000",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FFBFDBFE",
          "fillColor": "#00000000",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 0.800000011920929,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 555.0,
          "y2": 2.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 6.0,
          "width": 350.0,
          "height": 14.0,
          "text": "[ShipCountry] subtotal   |   Count: [COUNT()]   |   Average: [ROUND(AVG(Freight),2)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": false,
          "fontItalic": true,
          "textColor": "#FF1E40AF",
          "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": 350.0,
          "y2": 6.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 350.0,
          "top": 6.0,
          "width": 100.0,
          "height": 14.0,
          "text": "Total:",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 9.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FF1E40AF",
          "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": 450.0,
          "y2": 6.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 450.0,
          "top": 6.0,
          "width": 100.0,
          "height": 14.0,
          "text": "[ROUND(SUM(Freight),2)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.0,
          "fontBold": true,
          "fontItalic": false,
          "textColor": "#FF1E40AF",
          "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": 550.0,
          "y2": 6.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 22.0,
          "width": 555.0,
          "height": 12.0,
          "text": "Min: [ROUND(MIN(Freight),2)]   Max: [ROUND(MAX(Freight),2)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 8.0,
          "fontBold": false,
          "fontItalic": true,
          "textColor": "#FF808080",
          "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": 555.0,
          "y2": 22.0
        }
      ]
    },
    {
      "type": "Summary",
      "height": 36.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Rectangle",
          "name": "",
          "left": 0.0,
          "top": 4.0,
          "width": 555.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": "#FF1E3A8A",
          "fillColor": "#FF1E3A8A",
          "horzAlign": "Left",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 0.5,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 555.0,
          "y2": 4.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 10.0,
          "top": 10.0,
          "width": 350.0,
          "height": 16.0,
          "text": "GRAND TOTAL   |   Count: [COUNT()]   |   Average: [ROUND(AVG(Freight),2)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.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": 360.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 360.0,
          "top": 10.0,
          "width": 90.0,
          "height": 16.0,
          "text": "Total:",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 10.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": 450.0,
          "y2": 10.0
        },
        {
          "type": "Label",
          "name": "",
          "left": 450.0,
          "top": 10.0,
          "width": 95.0,
          "height": 16.0,
          "text": "[ROUND(SUM(Freight),2)]",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 11.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": 545.0,
          "y2": 10.0
        }
      ]
    },
    {
      "type": "PageFooter",
      "height": 16.0,
      "dataSource": "",
      "groupCondition": "",
      "elements": [
        {
          "type": "Label",
          "name": "",
          "left": 0.0,
          "top": 2.0,
          "width": 555.0,
          "height": 12.0,
          "text": "FmxPdfTools - Aggregate (SUM/AVG/COUNT/MIN/MAX) demo",
          "dataField": "",
          "imageFile": "",
          "wordWrap": false,
          "fontName": "Segoe UI",
          "fontSize": 8.0,
          "fontBold": false,
          "fontItalic": false,
          "textColor": "#FF808080",
          "backColor": "#00000000",
          "borderColor": "#FF000000",
          "strokeColor": "#FF000000",
          "fillColor": "#00000000",
          "horzAlign": "Center",
          "vertAlign": "Center",
          "borderWidth": 1.0,
          "strokeWidth": 1.0,
          "cornerX": 5.0,
          "cornerY": 5.0,
          "checked": false,
          "x2": 555.0,
          "y2": 2.0
        }
      ]
    }
  ]
}