Build a simple Chart

Steps:

  1. Follow Build a Generic Report until the step to add report parts.
  2. Prepare an empty ReportPartChart object with default properties.
  3. For each selected data source fields, populate a ReportPartElement object with default properties.
  4. Add the ReportPartElement objects into either labels.elements, values.elements, valuesLabels.elements, separators.elements or bubbleSize.elements in ReportPartChart object.
  5. Update the properties of the chart in properties field per user selection (See ReportPartChartProperties).
  6. Back to the steps in Build a Generic Report.

Prepare an empty ReportPartChart object

Empty ReportPartChart object


  • The highlighted labels.elements, values.elements, valuesLabels.elements, separators.elements and bubbleSize.elements are where the selected data source fields will be added
  • The highlighted properties contains the default properties
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
{
   "type": 0,
   "title": {
      "text": "",
      "properties": {},
      "settings": {
         "font": {
            "family": "",
            "size": 14,
            "bold": true,
            "italic": false,
            "underline": false,
            "color": "",
            "highlightColor": ""
         },
         "alignment": {
            "alignment": ""
         }
      },
      "elements": []
   },
   "description": {
      "text": "",
      "properties": {},
      "settings": {
         "font": {
            "family": "",
            "size": 14,
            "bold": false,
            "italic": false,
            "underline": false,
            "color": "",
            "highlightColor": ""
         },
         "alignment": {
            "alignment": ""
         }
      },
      "elements": []
   },
   "labels": {
      "elements": [],
      "name": "labels"
   },
   "values": {
      "elements": [],
      "name": "values"
   },
   "valuesLabels": {
      "elements": [],
      "name": "valuesLabels"
   },
   "separators": {
      "elements": [],
      "name": "separators"
   },
   "bubbleSize": {
      "elements": [],
      "name": "bubbleSize"
   },
   "properties": {
      "staticProperties": {},
      "chartType": "Line",
      "commonOptions": {
         "izHoverLabels": true,
         "izLegend.visibility": false,
         "izLegend.horizontalAlign": "izRight",
         "izLegend.verticalAlign": "izBottom",
         "izLegend.borderWidth": 0,
         "izChartStyle": {},
         "izendaHiddenAllAxis": false
      },
      "optionByType": {
         "izTotalLabel": "",
         "izUseSeparator": true,
         "izInverted": false,
         "izSpline": false,
         "izValueLabel": false,
         "legendSettings": true
      },
      "view": {
         "dataRefreshInterval": {
            "enable": false,
            "updateInterval": 0,
            "isAll": true,
            "latestRecord": 0
         }
      },
      "commonXYAxis": {},
      "printing": {
         "izPageBreakAfterSeparator": false
      }
   }
}

Populate selected data sources fields

  1. Refer to the similar step in Building a Grid guide to:

    1. Get the list of available data sources fields from POST report/availableQuerySourceFields
    2. Build a corresponding ReportPartElement object for each selected data source field
    3. Populate a default ReportPartElementProperties for properties field in each ReportPartElement object

    See Sample Properties for a ReportPartElement for some samples.

  2. Add the ReportPartElement objects into labels.elements, values.elements, valuesLabels.elements, separators.elements or bubbleSize.elements in ReportPartChart object.

    Sample full ReportPartChart object

    • Highlighted in labels.elements is the ReportPartElement for GROUP(OrderDate)
    • Highlighted in values.elements is the ReportPartElement for SUM(Freight)


      1
      2
      3
      4
      5
      6
      7
      8
      9
     10
     11
     12
     13
     14
     15
     16
     17
     18
     19
     20
     21
     22
     23
     24
     25
     26
     27
     28
     29
     30
     31
     32
     33
     34
     35
     36
     37
     38
     39
     40
     41
     42
     43
     44
     45
     46
     47
     48
     49
     50
     51
     52
     53
     54
     55
     56
     57
     58
     59
     60
     61
     62
     63
     64
     65
     66
     67
     68
     69
     70
     71
     72
     73
     74
     75
     76
     77
     78
     79
     80
     81
     82
     83
     84
     85
     86
     87
     88
     89
     90
     91
     92
     93
     94
     95
     96
     97
     98
     99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
    154
    155
    156
    157
    158
    159
    160
    161
    162
    163
    164
    165
    166
    167
    168
    169
    170
    171
    172
    173
    174
    175
    176
    177
    178
    179
    180
    181
    182
    183
    184
    185
    186
    187
    188
    189
    190
    191
    192
    193
    194
    195
    196
    197
    198
    199
    200
    201
    202
    203
    204
    205
    206
    207
    208
    209
    210
    211
    212
    213
    214
    215
    216
    217
    218
    219
    220
    221
    222
    223
    224
    225
    226
    227
    228
    229
    230
    231
    232
    233
    234
    235
    236
    237
    238
    239
    240
    241
    242
    243
    244
    245
    246
    247
    248
    249
    250
    251
    252
    253
    254
    255
    256
    257
    258
    259
    260
    261
    262
    263
    264
    265
    266
    267
    268
    269
    270
    271
    272
    273
    274
    275
    276
    277
    278
    279
    280
    281
    282
    283
    284
    285
    286
    287
    288
    289
    290
    291
    292
    293
    294
    295
    296
    297
    298
    299
    300
    301
    302
    303
    304
    305
    306
    307
    308
    309
    310
    311
    312
    313
    314
    315
    316
    317
    318
    319
    320
    321
    322
    323
    324
    325
    326
    327
    328
    329
    330
    331
    332
    333
    334
    335
    336
    337
    338
    339
    340
    341
    342
    343
    344
    345
    346
    347
    348
    349
    350
    {
       "type": 0,
       "title": {
          "text": "",
          "properties": {},
          "settings": {
             "font": {
                "family": "",
                "size": 14,
                "bold": true,
                "italic": false,
                "underline": false,
                "color": "",
                "highlightColor": ""
             },
             "alignment": {
                "alignment": ""
             }
          },
          "elements": []
       },
       "description": {
          "text": "",
          "properties": {},
          "settings": {
             "font": {
                "family": "",
                "size": 14,
                "bold": false,
                "italic": false,
                "underline": false,
                "color": "",
                "highlightColor": ""
             },
             "alignment": {
                "alignment": ""
             }
          },
          "elements": []
       },
       "labels": {
          "elements": [
             {
                "name": "OrderDate",
                "properties": {
                   "fieldItemVisible": true,
                   "dataFormattings": {
                      "function": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
                      "functionInfo": {
                         "id": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
                         "name": "Group",
                         "expression": null,
                         "dataType": "Datetime",
                         "formatDataType": "Datetime",
                         "syntax": null,
                         "expressionSyntax": null,
                         "isOperator": false,
                         "userDefined": false,
                         "extendedProperties": {}
                      },
                      "format": {
                         "formatId": "76875180-32c1-4180-b92f-03bdb14c4f6a",
                         "format": "Year",
                         "groupBy": "year",
                         "formatDataType": null,
                         "createNewHiddenPercenOfGroupField": false
                      },
                      "font": {
                         "family": "Roboto",
                         "size": 14,
                         "bold": false,
                         "italic": false,
                         "underline": false,
                         "color": "",
                         "backgroundColor": ""
                      },
                      "width": {
                         "value": null
                      },
                      "alignment": "alignLeft",
                      "sort": "ASC",
                      "color": {
                         "textColor": {
                            "rangePercent": null,
                            "rangeValue": null,
                            "value": null
                         },
                         "cellColor": {
                            "rangePercent": null,
                            "rangeValue": null,
                            "value": null
                         }
                      },
                      "alternativeText": {
                         "rangePercent": null,
                         "rangeValue": null,
                         "value": null
                      },
                      "customURL": {
                         "url": "",
                         "option": "LINK_NEW_WINDOW"
                      },
                      "embeddedJavascript": {
                         "script": ""
                      },
                      "subTotal": {
                         "label": "",
                         "function": "",
                         "expression": "",
                         "dataType": "",
                         "format": {},
                         "previewResult": ""
                      },
                      "grandTotal": {
                         "label": "",
                         "function": "",
                         "expression": "",
                         "dataType": "",
                         "format": {},
                         "previewResult": ""
                      }
                   },
                   "headerFormating": {
                      "font": {
                         "family": null,
                         "size": null,
                         "bold": null,
                         "italic": null,
                         "underline": null,
                         "color": null,
                         "backgroundColor": null
                      },
                      "alignment": null,
                      "wordWrap": null,
                      "columnGroup": ""
                   },
                   "drillDown": {
                      "subReport": {
                         "selectedReport": null,
                         "style": null,
                         "reportPartUsed": null,
                         "reportFilter": true,
                         "mappingFields": [],
                         "selectedIconValue": {
                            "icon": null,
                            "value": null
                         },
                         "viewSettingByLink": null
                      }
                   },
                   "otherProps": {}
                },
                "position": 1,
                "field": {
                   "fieldId": "fbf031a0-3e2d-49e7-972e-fffc98b634e5",
                   "fieldName": "OrderDate",
                   "fieldNameAlias": "OrderDate",
                   "dataFieldType": "Datetime",
                   "querySourceId": "af773c7b-878e-461b-9345-27ee6592db1a",
                   "querySourceType": "Table",
                   "sourceAlias": "Orders",
                   "relationshipId": null,
                   "visible": true,
                   "calculatedTree": null,
                   "schemaName": "dbo",
                   "querySourceName": "Orders",
                   "databaseName": "test",
                   "isCalculated": false,
                   "hasAggregatedFunction": false
                }
             }
          ],
          "name": "labels"
       },
       "values": {
          "elements": [
             {
                "name": "Sum (Freight)",
                "properties": {
                   "fieldItemVisible": true,
                   "dataFormattings": {
                      "function": "902a9168-fc01-4a35-92fb-ea67942d099d",
                      "functionInfo": {
                         "id": "902a9168-fc01-4a35-92fb-ea67942d099d",
                         "name": "Sum",
                         "expression": null,
                         "dataType": "Money",
                         "formatDataType": "Money",
                         "syntax": null,
                         "expressionSyntax": null,
                         "isOperator": false,
                         "userDefined": false,
                         "extendedProperties": {}
                      },
                      "format": {
                         "createNewHiddenPercenOfGroupField": false
                      },
                      "font": {
                         "family": "Roboto",
                         "size": 14,
                         "bold": false,
                         "italic": false,
                         "underline": false,
                         "color": "",
                         "backgroundColor": ""
                      },
                      "width": {
                         "value": null
                      },
                      "alignment": "alignLeft",
                      "sort": "ASC",
                      "color": {
                         "textColor": {
                            "rangePercent": null,
                            "rangeValue": null,
                            "value": null
                         },
                         "cellColor": {
                            "rangePercent": null,
                            "rangeValue": null,
                            "value": null
                         }
                      },
                      "alternativeText": {
                         "rangePercent": null,
                         "rangeValue": null,
                         "value": null
                      },
                      "customURL": {
                         "url": "",
                         "option": "LINK_NEW_WINDOW"
                      },
                      "embeddedJavascript": {
                         "script": ""
                      },
                      "subTotal": {
                         "label": "",
                         "function": "",
                         "expression": "",
                         "dataType": "",
                         "format": {},
                         "previewResult": ""
                      },
                      "grandTotal": {
                         "label": "",
                         "function": "",
                         "expression": "",
                         "dataType": "",
                         "format": {},
                         "previewResult": ""
                      }
                   },
                   "headerFormating": {
                      "font": {
                         "family": null,
                         "size": null,
                         "bold": null,
                         "italic": null,
                         "underline": null,
                         "color": null,
                         "backgroundColor": null
                      },
                      "alignment": null,
                      "wordWrap": null,
                      "columnGroup": ""
                   },
                   "drillDown": {
                      "subReport": {
                         "selectedReport": null,
                         "style": null,
                         "reportPartUsed": null,
                         "reportFilter": true,
                         "mappingFields": [],
                         "selectedIconValue": {
                            "icon": null,
                            "value": null
                         },
                         "viewSettingByLink": null
                      }
                   },
                   "otherProps": {}
                },
                "position": 1,
                "field": {
                   "fieldId": "61b3c4ad-cbd4-49b0-9385-540568397e05",
                   "fieldName": "Freight",
                   "fieldNameAlias": "Sum (Freight)",
                   "dataFieldType": "Money",
                   "querySourceId": "af773c7b-878e-461b-9345-27ee6592db1a",
                   "querySourceType": "Table",
                   "sourceAlias": "Orders",
                   "relationshipId": null,
                   "visible": true,
                   "calculatedTree": null,
                   "schemaName": "dbo",
                   "querySourceName": "Orders",
                   "databaseName": "test",
                   "isCalculated": false,
                   "hasAggregatedFunction": false
                }
             }
          ],
          "name": "values"
       },
       "valuesLabels": {
          "elements": [],
          "name": "valuesLabels"
       },
       "separators": {
          "elements": [],
          "name": "separators"
       },
       "bubbleSize": {
          "elements": [],
          "name": "bubbleSize"
       },
       "properties": {
          "staticProperties": {},
          "chartType": "Line",
          "commonOptions": {
             "izHoverLabels": true,
             "izLegend.visibility": false,
             "izLegend.horizontalAlign": "izRight",
             "izLegend.verticalAlign": "izBottom",
             "izLegend.borderWidth": 0,
             "izChartStyle": {},
             "izendaHiddenAllAxis": false
          },
          "optionByType": {
             "izTotalLabel": "",
             "izUseSeparator": true,
             "izInverted": false,
             "izSpline": false,
             "izValueLabel": false,
             "legendSettings": true
          },
          "view": {
             "dataRefreshInterval": {
                "enable": false,
                "updateInterval": 0,
                "isAll": true,
                "latestRecord": 0
             }
          },
          "commonXYAxis": {},
          "printing": {
             "izPageBreakAfterSeparator": false
          }
       }
    }
    

Update the properties of each field per user selection

Please see ReportPartElementProperties for the purpose of each field.

See Sample Properties for a ReportPartElement for more samples.

Update the properties of the Chart in “properties” field per user selection

Please see ReportPartChartProperties for the purpose of each field.

Back to the Save step in Build a Generic Report

Sample full ReportSavingParameter object for Save report API
{
   "reportKey": {
      "key": "5f71f8c8-dc8d-47f4-9253-3594d1114fc5",
      "tenantId": null
   },
   "section": 2,
   "saveAs": false,
   "ignoreCheckChange": false,
   "report": {
      "inaccessible": false,
      "category": {
         "name": "TestCategory",
         "type": 0,
         "parentId": null,
         "tenantId": null,
         "canDelete": false,
         "editable": false,
         "savable": false,
         "subCategories": [],
         "checked": false,
         "reports": null,
         "dashboards": null,
         "id": "1bf05555-def3-43e1-ada2-f326217b72f1",
         "state": 0,
         "deleted": false,
         "inserted": true,
         "version": null,
         "created": null,
         "createdBy": "John Doe",
         "modified": null,
         "modifiedBy": null
      },
      "subCategory": {
         "name": "",
         "type": 0,
         "parentId": null,
         "tenantId": null,
         "canDelete": false,
         "editable": false,
         "savable": false,
         "subCategories": [],
         "checked": false,
         "reports": null,
         "dashboards": null,
         "id": null,
         "state": 0,
         "deleted": false,
         "inserted": true,
         "version": null,
         "created": null,
         "createdBy": "John Doe",
         "modified": null,
         "modifiedBy": null
      },
      "reportRelationship": [],
      "reportPart": [
         {
            "reportPartContent": {
               "type": 0,
               "title": {
                  "text": "",
                  "properties": {},
                  "settings": {
                     "font": {
                        "family": "",
                        "size": 14,
                        "bold": true,
                        "italic": false,
                        "underline": false,
                        "color": "",
                        "highlightColor": ""
                     },
                     "alignment": {
                        "alignment": ""
                     }
                  },
                  "elements": []
               },
               "description": {
                  "text": "",
                  "properties": {},
                  "settings": {
                     "font": {
                        "family": "",
                        "size": 14,
                        "bold": false,
                        "italic": false,
                        "underline": false,
                        "color": "",
                        "highlightColor": ""
                     },
                     "alignment": {
                        "alignment": ""
                     }
                  },
                  "elements": []
               },
               "labels": {
                  "elements": [
                     {
                        "name": "OrderDate",
                        "properties": {
                           "fieldItemVisible": true,
                           "dataFormattings": {
                              "function": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
                              "functionInfo": {
                                 "id": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
                                 "name": "Group",
                                 "expression": null,
                                 "dataType": "Datetime",
                                 "formatDataType": "Datetime",
                                 "syntax": null,
                                 "expressionSyntax": null,
                                 "isOperator": false,
                                 "userDefined": false,
                                 "extendedProperties": {}
                              },
                              "format": {
                                 "formatId": "76875180-32c1-4180-b92f-03bdb14c4f6a",
                                 "format": "Year",
                                 "groupBy": "year",
                                 "formatDataType": null,
                                 "createNewHiddenPercenOfGroupField": false
                              },
                              "font": {
                                 "family": "Roboto",
                                 "size": 14,
                                 "bold": false,
                                 "italic": false,
                                 "underline": false,
                                 "color": "",
                                 "backgroundColor": ""
                              },
                              "width": {
                                 "value": null
                              },
                              "alignment": "alignLeft",
                              "sort": "ASC",
                              "color": {
                                 "textColor": {
                                    "rangePercent": null,
                                    "rangeValue": null,
                                    "value": null
                                 },
                                 "cellColor": {
                                    "rangePercent": null,
                                    "rangeValue": null,
                                    "value": null
                                 }
                              },
                              "alternativeText": {
                                 "rangePercent": null,
                                 "rangeValue": null,
                                 "value": null
                              },
                              "customURL": {
                                 "url": "",
                                 "option": "LINK_NEW_WINDOW"
                              },
                              "embeddedJavascript": {
                                 "script": ""
                              },
                              "subTotal": {
                                 "label": "",
                                 "function": "",
                                 "expression": "",
                                 "dataType": "",
                                 "format": {},
                                 "previewResult": ""
                              },
                              "grandTotal": {
                                 "label": "",
                                 "function": "",
                                 "expression": "",
                                 "dataType": "",
                                 "format": {},
                                 "previewResult": ""
                              }
                           },
                           "headerFormating": {
                              "font": {
                                 "family": null,
                                 "size": null,
                                 "bold": null,
                                 "italic": null,
                                 "underline": null,
                                 "color": null,
                                 "backgroundColor": null
                              },
                              "alignment": null,
                              "wordWrap": null,
                              "columnGroup": ""
                           },
                           "drillDown": {
                              "subReport": {
                                 "selectedReport": null,
                                 "style": null,
                                 "reportPartUsed": null,
                                 "reportFilter": true,
                                 "mappingFields": [],
                                 "selectedIconValue": {
                                    "icon": null,
                                    "value": null
                                 },
                                 "viewSettingByLink": null
                              }
                           },
                           "otherProps": {}
                        },
                        "position": 1,
                        "field": {
                           "fieldId": "fbf031a0-3e2d-49e7-972e-fffc98b634e5",
                           "fieldName": "OrderDate",
                           "fieldNameAlias": "OrderDate",
                           "dataFieldType": "Datetime",
                           "querySourceId": "af773c7b-878e-461b-9345-27ee6592db1a",
                           "querySourceType": "Table",
                           "sourceAlias": "Orders",
                           "relationshipId": null,
                           "visible": true,
                           "calculatedTree": null,
                           "schemaName": "dbo",
                           "querySourceName": "Orders",
                           "databaseName": "test",
                           "isCalculated": false,
                           "hasAggregatedFunction": false
                        }
                     }
                  ],
                  "name": "labels"
               },
               "values": {
                  "elements": [
                     {
                        "name": "Sum (Freight)",
                        "properties": {
                           "fieldItemVisible": true,
                           "dataFormattings": {
                              "function": "902a9168-fc01-4a35-92fb-ea67942d099d",
                              "functionInfo": {
                                 "id": "902a9168-fc01-4a35-92fb-ea67942d099d",
                                 "name": "Sum",
                                 "expression": null,
                                 "dataType": "Money",
                                 "formatDataType": "Money",
                                 "syntax": null,
                                 "expressionSyntax": null,
                                 "isOperator": false,
                                 "userDefined": false,
                                 "extendedProperties": {}
                              },
                              "format": {
                                 "createNewHiddenPercenOfGroupField": false
                              },
                              "font": {
                                 "family": "Roboto",
                                 "size": 14,
                                 "bold": false,
                                 "italic": false,
                                 "underline": false,
                                 "color": "",
                                 "backgroundColor": ""
                              },
                              "width": {
                                 "value": null
                              },
                              "alignment": "alignLeft",
                              "sort": "ASC",
                              "color": {
                                 "textColor": {
                                    "rangePercent": null,
                                    "rangeValue": null,
                                    "value": null
                                 },
                                 "cellColor": {
                                    "rangePercent": null,
                                    "rangeValue": null,
                                    "value": null
                                 }
                              },
                              "alternativeText": {
                                 "rangePercent": null,
                                 "rangeValue": null,
                                 "value": null
                              },
                              "customURL": {
                                 "url": "",
                                 "option": "LINK_NEW_WINDOW"
                              },
                              "embeddedJavascript": {
                                 "script": ""
                              },
                              "subTotal": {
                                 "label": "",
                                 "function": "",
                                 "expression": "",
                                 "dataType": "",
                                 "format": {},
                                 "previewResult": ""
                              },
                              "grandTotal": {
                                 "label": "",
                                 "function": "",
                                 "expression": "",
                                 "dataType": "",
                                 "format": {},
                                 "previewResult": ""
                              }
                           },
                           "headerFormating": {
                              "font": {
                                 "family": null,
                                 "size": null,
                                 "bold": null,
                                 "italic": null,
                                 "underline": null,
                                 "color": null,
                                 "backgroundColor": null
                              },
                              "alignment": null,
                              "wordWrap": null,
                              "columnGroup": ""
                           },
                           "drillDown": {
                              "subReport": {
                                 "selectedReport": null,
                                 "style": null,
                                 "reportPartUsed": null,
                                 "reportFilter": true,
                                 "mappingFields": [],
                                 "selectedIconValue": {
                                    "icon": null,
                                    "value": null
                                 },
                                 "viewSettingByLink": null
                              }
                           },
                           "otherProps": {}
                        },
                        "position": 1,
                        "field": {
                           "fieldId": "61b3c4ad-cbd4-49b0-9385-540568397e05",
                           "fieldName": "Freight",
                           "fieldNameAlias": "Sum (Freight)",
                           "dataFieldType": "Money",
                           "querySourceId": "af773c7b-878e-461b-9345-27ee6592db1a",
                           "querySourceType": "Table",
                           "sourceAlias": "Orders",
                           "relationshipId": null,
                           "visible": true,
                           "calculatedTree": null,
                           "schemaName": "dbo",
                           "querySourceName": "Orders",
                           "databaseName": "test",
                           "isCalculated": false,
                           "hasAggregatedFunction": false
                        }
                     }
                  ],
                  "name": "values"
               },
               "valuesLabels": {
                  "elements": [],
                  "name": "valuesLabels"
               },
               "separators": {
                  "elements": [],
                  "name": "separators"
               },
               "bubbleSize": {
                  "elements": [],
                  "name": "bubbleSize"
               },
               "properties": {
                  "staticProperties": {},
                  "chartType": "Line",
                  "commonOptions": {
                     "izHoverLabels": true,
                     "izLegend.visibility": false,
                     "izLegend.horizontalAlign": "izRight",
                     "izLegend.verticalAlign": "izBottom",
                     "izLegend.borderWidth": 0,
                     "izChartStyle": {},
                     "izendaHiddenAllAxis": false
                  },
                  "optionByType": {
                     "izTotalLabel": "",
                     "izUseSeparator": true,
                     "izInverted": false,
                     "izSpline": false,
                     "izValueLabel": false,
                     "legendSettings": true
                  },
                  "view": {
                     "dataRefreshInterval": {
                        "enable": false,
                        "updateInterval": 0,
                        "isAll": true,
                        "latestRecord": 0
                     }
                  },
                  "commonXYAxis": {},
                  "printing": {
                     "izPageBreakAfterSeparator": false
                  }
               }
            },
            "width": 12,
            "height": 4,
            "positionY": 0,
            "positionX": 0,
            "title": "Grid"
         }
      ],
      "reportFilter": {
         "filterFields": [],
         "logic": "",
         "visible": true,
         "reportId": "5f71f8c8-dc8d-47f4-9253-3594d1114fc5",
         "id": "dc7aa7bd-f79f-4a92-8f87-9dd35d88e193",
         "state": 0,
         "deleted": false,
         "inserted": true,
         "version": null,
         "created": null,
         "createdBy": "John Doe",
         "modified": null,
         "modifiedBy": null
      },
      "calculatedFields": [],
      "accesses": [],
      "schedules": [],
      "dynamicQuerySourceFields": [],
      "name": "Example Report Name 15",
      "reportDataSource": [
         {
            "reportId": "5f71f8c8-dc8d-47f4-9253-3594d1114fc5",
            "querySourceId": "af773c7b-878e-461b-9345-27ee6592db1a",
            "querySourceCategoryId": null,
            "connectionId": null,
            "selected": true,
            "id": "306b7863-6731-4359-8f5b-e8f1c000167c",
            "state": 1,
            "deleted": false,
            "inserted": false,
            "version": null,
            "created": null,
            "createdBy": "John Doe",
            "modified": null,
            "modifiedBy": null
         }
      ],
      "type": 0,
      "previewRecord": 10,
      "advancedMode": true,
      "allowNulls": false,
      "isDistinct": false,
      "categoryId": "1bf05555-def3-43e1-ada2-f326217b72f1",
      "categoryName": null,
      "subCategoryId": null,
      "subCategoryName": null,
      "tenantId": null,
      "tenantName": null,
      "description": "",
      "title": "",
      "lastViewed": null,
      "owner": "John Doe",
      "ownerId": "9fc0f5c2-decf-4d65-9344-c59a1704ea0c",
      "excludedRelationships": null,
      "numberOfView": 0,
      "renderingTime": 0,
      "createdById": "9fc0f5c2-decf-4d65-9344-c59a1704ea0c",
      "modifiedById": "9fc0f5c2-decf-4d65-9344-c59a1704ea0c",
      "snapToGrid": false,
      "usingFields": null,
      "hasDeletedObjects": false,
      "header": {
         "visible": false,
         "items": [
            {
               "isDirty": false,
               "type": "image",
               "label": "Image",
               "id": "formatDetails_57",
               "positionX": 0,
               "positionY": 0,
               "width": 6,
               "height": 6,
               "name": "Logo Image",
               "value": "",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "imageUrl": "http://",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_58",
               "positionX": 20,
               "positionY": 0,
               "width": 12,
               "height": 2,
               "name": "Report Name",
               "value": "{reportName}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "thinHorizontalRule",
               "label": "Horizontal Rule",
               "id": "formatDetails_59",
               "positionX": 20,
               "positionY": 4,
               "width": 12,
               "height": 1,
               "name": "Upper Separator Line",
               "value": "{horizontalRule}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 2
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_60",
               "positionX": 20,
               "positionY": 5,
               "width": 6,
               "height": 2,
               "name": "Report Generated",
               "value": "Report Generated:",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_61",
               "positionX": 20,
               "positionY": 7,
               "width": 6,
               "height": 2,
               "name": "User",
               "value": "User:",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_62",
               "positionX": 20,
               "positionY": 9,
               "width": 6,
               "height": 2,
               "name": "Tenant",
               "value": "Tenant:",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "dateTime",
               "label": "Date Time",
               "id": "formatDetails_63",
               "positionX": 26,
               "positionY": 5,
               "width": 6,
               "height": 2,
               "name": "Current Date Time",
               "value": "{currentDateTime}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_64",
               "positionX": 26,
               "positionY": 7,
               "width": 6,
               "height": 2,
               "name": "Current User Name",
               "value": "{currentUserName}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_65",
               "positionX": 26,
               "positionY": 9,
               "width": 6,
               "height": 2,
               "name": "Tenant Name",
               "value": "{tenantName}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "horizontalRule",
               "label": "Horizontal Rule",
               "id": "formatDetails_66",
               "positionX": 0,
               "positionY": 11,
               "width": 32,
               "height": 1,
               "name": "Lower Separator Line",
               "value": "{horizontalRule}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 4
            }
         ]
      },
      "footer": {
         "visible": false,
         "items": [
            {
               "isDirty": false,
               "type": "horizontalRule",
               "label": "Horizontal Rule",
               "id": "formatDetails_67",
               "positionX": 0,
               "positionY": 0,
               "width": 32,
               "height": 1,
               "name": "Separator Line",
               "value": "{horizontalRule}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 4
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_68",
               "positionX": 0,
               "positionY": 1,
               "width": 10,
               "height": 2,
               "name": "Footer Text",
               "value": "Footer Text",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "text",
               "label": "Text",
               "id": "formatDetails_69",
               "positionX": 20,
               "positionY": 1,
               "width": 4,
               "height": 2,
               "name": "Page",
               "value": "Page",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "pageNumber",
               "label": "Page Number",
               "id": "formatDetails_70",
               "positionX": 24,
               "positionY": 1,
               "width": 8,
               "height": 2,
               "name": "Page Number",
               "value": "{pageNumber}",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            }
         ]
      },
      "titleDescription": {
         "visible": false,
         "items": [
            {
               "isDirty": false,
               "type": "title",
               "label": "Title",
               "id": "formatDetails_71",
               "name": "Title",
               "value": "",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            },
            {
               "isDirty": false,
               "type": "description",
               "label": "Description",
               "id": "formatDetails_72",
               "name": "Description",
               "value": "",
               "font": {
                  "family": "Roboto",
                  "size": 14,
                  "bold": false,
                  "italic": false,
                  "underline": false,
                  "color": "#000",
                  "backgroundColor": "#fff"
               },
               "color": "#000",
               "dashStyle": "solid",
               "thickness": 1
            }
         ]
      },
      "sourceId": null,
      "checked": false,
      "copyDashboard": false,
      "exportFormatSetting": {
         "orientation": 0,
         "margins": 0,
         "centerOnPage": {
            "horizontally": false,
            "vertically": false
         },
         "pageBreakAfterReportPart": false,
         "marginSettings": [
            {
               "type": 3,
               "topValue": 0.75,
               "bottomValue": 0.75,
               "leftValue": 0.7,
               "rightValue": 0.7,
               "headerValue": 0.3,
               "footerValue": 0.3
            },
            {
               "type": 0,
               "topValue": 0.75,
               "bottomValue": 0.75,
               "leftValue": 0.7,
               "rightValue": 0.7,
               "headerValue": 0.3,
               "footerValue": 0.3
            },
            {
               "type": 1,
               "topValue": 0.75,
               "bottomValue": 0.75,
               "leftValue": 0.25,
               "rightValue": 0.25,
               "headerValue": 0.3,
               "footerValue": 0.3
            },
            {
               "type": 2,
               "topValue": 1,
               "bottomValue": 1,
               "leftValue": 1,
               "rightValue": 1,
               "headerValue": 0.5,
               "footerValue": 0.5
            }
         ]
      },
      "deletable": false,
      "editable": false,
      "movable": false,
      "copyable": false,
      "accessPriority": 0,
      "active": false,
      "id": "5f71f8c8-dc8d-47f4-9253-3594d1114fc5",
      "state": 1,
      "deleted": false,
      "inserted": false,
      "version": 0,
      "created": null,
      "createdBy": "John Doe",
      "modified": null,
      "modifiedBy": "John Doe"
   }
}