Specifies whether object properties in report views are flattened into individual columns.

Data Type

bool

Default Value

true

Remarks

This property applies only to report views. It does not affect other tables.

When set to true (the default), the provider flattens object properties in report data into separate columns. The column name is generated by concatenating the parent object name and property name with a dot separator.

When set to false, only the first-level objects are displayed as columns, and objects nested within arrays are returned as JSON strings instead of flattened columns. To access the values of those aggregates, you can use the JSON_EXTRACT function.

The following example shows how nested objects in report data are flattened:

[
  { "grade": "A", "score": 2 },
  { "grade": "A", "score": 6 },
  { "grade": "A", "score": 10 }
]

When FlattenReportObjects is set to true and FlattenReportsArrayDepth is set to 1, the array above is flattened into the following columns:

Flattening objects simplifies querying nested report data but can increase the number of columns when applied to deeply nested structures.