Creating reports and dashboards | Stimulsoft community forum

Hello,
I have a question in Stimulsoft Reports.JS Designer, I have a data file in JSON format.
In the data there is an array, I want to put all the information in this array inside just one column.
It's possible?

Hello,

Please send us your JSON file for analysis.

Thank you.

{
"header": {
"title": "Relatório de Área",
"subtitle": "Filtrado pelo Nome (MARIA OLIVEIRA), pelo Documento (RG 12345678) e ordenado por Nome",
"periodo": "Periodo: 11/04/2021 08:00 - 11/04/2021 23:59",
"organizacao": "NEXCODE SYSTEMS",
"contador": "Total de registros: 1000",
"logoAplicacao": "",
"logoOrganizacao": ""
},
"data": {
"reparticaoArea": {
"nodes": [
{
"id": 1191,
"name": "AREA ALPHA",
"type": 1,
"sectorId": 108,
"sector": {
"id": 108,
"name": "ALPHA DELTA"
},
"blockages": [
{
"areaId": 1191,
"name": "BLOQUEIO ALPHA"
},
{
"areaId": 1191,
"name": "BLOQUEIO BRAVO"
},
{
"areaId": 1191,
"name": "BLOQUEIO CHARLIE"
},
{
"areaId": 1191,
"name": "BLOQUEIO DELTA"
}
]
}
]
}
}
}

Hello,

You can add your JSON as data source and then create report as you need.

Thank you.

If I knew how to create, I wouldn't be asking for support, right? haha.
My json is already added to the Data Source, I just need to know expression or some column type that supports JSON arrays and list.

Thank you.

Hello,

To show an array of records, you should use the DataBand component. To display nested objects, you can use the master-detail construction:
https://www.stimulsoft.com/en/documenta ... report.htm

Thank you.

Hi it's me again hahahaha
I swear it's the last time! xD
I have a question about conditions, I read the documentation but didn't find the solution.
I'm trying to put the condition "is not null" in a column and assign expression but it doesn't work.
Thank you!

Hello,

For string columns please try to check by empty values not by null:
datasource.column == ""

Thank you.