asd.backup
-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by asd.backup
-
-
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!
Create subreports with json
in Products
Posted
I I already found the solution. It's simple, in the main report I added the route.