asd.backup

I I already found the solution. It's simple, in the main report I added the route. DetailPerRut Also, within the main report, I added the sub report element with the following settings within the properties. ((Net.sf.jasperreports.engine.data.JsonDataSource) $ P {REPORT_DATA_SOURCE}). SubDataSource ("Gifts.Details"). I hope someone helps this solution.

Hi everyone, I have a problem working with the Json data source and subreports. I have the following json: { "DetailPerRut": { "Name": { "Var1": "Lily", "Var2": "city1", "Var3": "a", "Var4": "b", "Var5": "c" } "Gifts": { "Details": [ { "Date": "12/12/2000", "Body": 2, "Page": 45, "Extract": 4, "Acr": "123456789-0", "Acr2": "test1" }, { "Date": "12/12/2010", "Body": 3, "Page": 33, "Extract": 6, "Acr": "123456789-0", "Acr2": "test2" } ] } } } I tried to create a main report and a sub report but the sub report does not show the information, nothing. I have read the little information about working with JSON but none help me much. I just want to show in the main report the detail of "Gifts" with a sub-report. And "DetailPerRut" in the main report. In "Gifts" I want to make a table that shows a header by register, that is. -------------------------------------------------- -------------------------------------------------- ---- | Date | Body | Page | Extract | Acr | Ac2 | -------------------------------------------------- -------------------------------------------------- ---- | 12/12/2000 | 2, | 45 | 4 | 123456789-0 | Test1 | -------------------------------------------------- -------------------------------------------------- ---- -------------------------------------------------- -------------------------------------------------- ---- | Date | Body | Page | Extract | Acr | Ac2 | -------------------------------------------------- -------------------------------------------------- ---- | 12/12/2000 | 2, | 45 | 4 | 123456789-0 | Test1 | -------------------------------------------------- -------------------------------------------------- ---- please, I need your help :D Thank you community !!

Thank you for your answer! But in my case, I didn't declare the total in the crosstable because I don't want show this variable in the table. I just want to show the total in the page header. please any idea for this ? Thank you !! Best regards.

Hi ! I have a question with a problem in Json. In the "Dataset and Query Dialog" there are our fields that will used. Here is the description field and with the XML we can to put function for example SUM, COUNT, ETC... To do this, we must put the node with the path that we want to go. For example "/node1/nodearray". In JSon we should use ".node1.nodearray" (is replaced " / " by " . ") but it does not work. please you help thank you!!

Hi everyone! I have a problem with the count columns of my crosstable. I just to put the count columns in the page header section od my reports. The problem is that the crosstable born of a dataset. How do you do? or is there anything for this? Thanks you !!

I want to "fecha", "periodo", "cod" in the header. the others are the report detail. I had a problem with the connection or configuration in the element "table". specifically in "show properties - Dataset". I had chosen "Use same jdbc connection used to fill the master report" but the solution (In this case with the format Json), I choose "Use a JRDDatasource expression" and I wrote the following: ((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("RootNode.Array") I've been watching this case all day for Json, since the configuration with XML is different. I hope that this solution will serve an others people. Regards and thanks for answering!

HI everyone, I hope that you understand me. I have looked for how to work with json but there are no examples that guide me. I need to create a table with this json: { "report": { "fecha": "15/02/2017-21/02/2017", "periodo": "12", "cod": "12", "Datos": { "baseDatosItem": [ { "baseDatos": "first", "variacionSin": { "variacion": "458", "variacionPorcentaje": "82.08" }, "variacionPositiva": { "variacion": "47", "variacionPorcentaje": "8.42" }, "variacionNegativa": { "variacion": "53", "variacionPorcentaje": "9.50" } }, { "baseDatos": "second", "variacionSin": { "variacion": "486", "variacionPorcentaje": "87.10" }, "variacionPositiva": { "variacion": "30", "variacionPorcentaje": "5.38" }, "variacionNegativa": { "variacion": "39", "variacionPorcentaje": "6.96" } }, { "baseDatos": "Third", "variacionSin": { "variacion": "557", "variacionPorcentaje": "100.00" }, "variacionPositiva": { "variacion": "0", "variacionPorcentaje": "0.00" }, "variacionNegativa": { "variacion": "0", "variacionPorcentaje": "0.00" } } ] } } } I need that: fecha : |periodo: |cod: | ------------------------------------------------------------ base de datos| sinVariacion | variacionPositiva | first 458 - 82.5 47 - 8.42 second 486 - 87.10 etc Third etc etc please you help, thanks!