Topics created by Haritz Lopez

I have installed localy and I am making some new tests. How could I change the xlsx.maxRows and xlsx.bufferSize? I am getting an error if the json is too big. with 15000 rows now works but with 20000 no.

preview error Got not ok response, status: 500 Error: Got not ok response, status: 500 at http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:41:78261 at m (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:311:73091) at Generator._invoke (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:311:72844) at forEach.e.<computed> [as next] (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:311:73271) at i (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:3:368084) at http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:3:368181

I changed already the timeout value.

{ "httpPort": 5488, "store": { "provider": "fs" }, "blobStorage": { "provider": "fs" }, "logger": { "console": { "transport": "console", "level": "debug" }, "file": { "transport": "file", "level": "info", "filename": "logs/reporter.log" }, "error": { "transport": "file", "level": "error", "filename": "logs/error.log" } }, "trustUserCode": false, "reportTimeout": 60000000, "workers": { "numberOfWorkers": 2 }, "extensions": { "authentication": { "cookieSession": {}, "admin": { "username": "admin", "password": "password" }, "enabled": false } } }

hi @Haritz-Lopez I think this is not possible at the moment in an easy way, of course, you can always use the xlsx transformation and that should allow you to do anything you want, but it is going to be more complex of course and also it will require you to spend time understanding the changes you need to make in the internal xml files of the xlsx.

i am working right now on having support for multi-rows each support, when that is implemented it should be possible to achieve this. basically, you will make an iteration that involves multiple rows, and those rows are going to be repeated based on that data.

Is this possible to do directly with jsreport or should I first, somehow, prepare the data and give everything "done" to jsreport?

you can also prepare the data inside the jsreport with a script or helpers, so you can transform it and group it based on your needs, but as described above you are going to need to have the muti-rows each to be supported in order to have this working easily for you, i am working on it.

For anyone wondering, I was able to solve the problem removing the #if inside the template. Yet I do not understand the reason behind that but removing it solved my issue about numbers being saved as text.