![](http://content.invisioncic.com/i328763/set_resources_3/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
DaveKay
-
Posts
4 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by DaveKay
-
-
Thank you for that ernesto :-)
I have just taken a look at the video and will try to apply what you have shown me. There are a few things there that I was not aware of.
What I would like to do in the end is have a report that shows the top level inspection data and loops through the sub level records (add_an_outlet, add_an_inlet, add_defect records for each inspection in either a table or a sub report using the Parameter and the PARENT_ID and ID relationship.
I really do appreciate you taking the time to create a step by step video for me...amazing!
I'd better get to it - will let you know how I go.
-
Thanks for taking a look ernestoo, the gist link is below - not used it before - just added an issue and pasted in the json, hope that's okay.
https://github.com/DaveKay/SampleJSON/issues/1
Regards
David
-
Hello all,
I'm trying to build a report using a json data feed - while I can access the first level of data within the feed I am unable to access any second level data. I'm not entirely sure I am using the correct terminolgy so I have provided a screen capture of the data source record tree (see below). What I'm trying to do is auto discover the field under record.add_outlet.record tree node, when I hit next the field list is empty.
This is a data source/set for a table within the report - ultimately I would like access the sub levels from a sub report.
I have tried to find a solution using various forums and can only find reference to solutions involving net.sf.jasperreports.engine.data.JsonDataSource and subdataSource which I'm strugging to understand yet alone implement.
I would appreciate any assiistance that could be provided. Should I continue to try and understand the JsonDataSource subDataSource approach or is there alternative solution?
I am using Jaspersoft Studio 6.0.3.
Kind Regards
David
How can I access nested json records?
in Products
Posted
Okay ernesto - I was able to replicate what you showed me. I'm still however struggling to get either a table or a sub form populated with data.
What I want to be able to is insert a table ( or a sub report ) that will report the 'add_an_outlet' records for each of the top level records. The add_an_outlet records are associated with the parent record via the PARENT_ID field.
record.ID --> record.add_an_outlet.record.PARENT_RECORD_ID ( 1 to many ).
I think what I need to do is similar to the sample described here;
http://jasperreports.sourceforge.net/sample.reference/jsondatasource/
and the json data source sample in the Jasper Report Library.
http://sourceforge.net/projects/jasperreports/files/jasperreports/JasperReports%206.0.3/jasperreports-6.0.3-project.zip/download
Hopefully you get what I mean and can still assist.
Kind Regards
David