How to display all contents of a json file in a flat report

Answered
Justin Shams asked on April 13, 2022

I just want to be able to display all the content of a report with the specified headers. Should be simple
 
[{
"Date": "1/18/2022",
"Time": "8:30:23 AM",
"Region": "Tri City Region",
"Office": "Traverse City",
"Business Unit": "Main",
"Return Group": "Default",
"Return ID": "2021I:MEED4796:v1",
"Return Name": "MEEDER, JUSTIN",
"Return Description": "",
"Year End": "12/31/2021",
"Federal": "1040 Individual",
"State": "MI",
"Other": "",
"User ID": "Dalton.Neumeier",
"Solution Package": "Yes"
},
{
"Date": "1/18/2022",
"Time": "11:44:58 AM",
"Region": "Tri City Region",
"Office": "Traverse City",
"Business Unit": "Main",
"Return Group": "Default",
"Return ID": "2021I:NELS3865:v1",
"Return Name": "Nelson, Matthew",
"Return Description": "",
"Year End": "12/31/2021",
"Federal": "1040 Individual",
"State": "MI,PA",
"Other": "",
"User ID": "Dalton.Neumeier",
"Solution Package": "Yes"
}]

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster April 15, 2022

Hello, Justin!

Thank you for contacting us.

We want to inform you that the specified data display can be achieved by setting the grid type property to flat.
The grid type can be changed at runtime from the Options Toolbar tab.
Also, we have prepared a simple example of how to set flat type via the report object: https://jsfiddle.net/flexmonster/jLksm7v1/

Hope it helps.

Regards,
Solomiia.

Please login or Register to Submit Answer