scott_ryan_1 Posted June 24, 2014 Share Posted June 24, 2014 I have a JSONDatasource that I want to use to create a report. The data contains a list of items I want to present in a Table. The data looks like:{ "sensors":{ "reportDate:"12-04-2014", "rows":[ {"eventCode":2},{"eventCode":3},{"eventCode":4},{"eventCode":5}] } }I am able to acces the report date with the following:<queryString language="json"> <![CDATA[sensors]]> </queryString> <field name="reportDate" class="java.lang.String"> <fieldDescription><![CDATA[reportDate]]></fieldDescription> </field>I cannot figure out how to use the rows in a table. There is not much on the web and the documentation and samples only talk about subreports which this is not. ThanksScott Link to comment Share on other sites More sharing options...
pravin_sarode Posted September 19, 2016 Share Posted September 19, 2016 Yes ,you are right ..No one is giving exact solution ,only talking other things. Am alsofacing this issue ,and trrying to find since week. but i didn't .. Link to comment Share on other sites More sharing options...
narcism Posted September 19, 2016 Share Posted September 19, 2016 I've recently posted an answer to a similar question on StackOverflow: http://stackoverflow.com/a/39568989/5882963Although my answer involves using a List due to its simpler syntax, the switch to a Table should be fairly easy.If you have any issues I'll add a complete solution for your case. Link to comment Share on other sites More sharing options...
vakhariaaman Posted May 21, 2018 Share Posted May 21, 2018 Please provide me complete solution. I have sean it but as I am new to jasper soft I am totally confused. If you can provide me jr xml code similar to my solution using json as shown in exmaple and table as shown in example having rowspan on <td> based on inner json list that would be really helpful for me.As we are on the peak of deadlines. Looking forward for your reply Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now