franxic Posted July 31, 2015 Share Posted July 31, 2015 Hi,I have a problem very similar tohttp://community.jaspersoft.com/questions/844023/need-help-looping-through-json,but I can't just change the json file as done by the person asking that question.Any help would be greatly appreciated. cheers! Link to comment Share on other sites More sharing options...
calculate.machine Posted August 26, 2015 Share Posted August 26, 2015 It is a hassle to convert a multi-level JSON file to a two-dimensional table using the report script. I think you could consider using esProc to prepare data that the report needs. The report then can access the esProc code via JDBC.A1=file("d:\source.json").read().import@j()A2=A1.news(custCars;A1.custName:custName,carMake,carModel,carMiles)Refer to http://blog.raqsoft.com/?p=4789 for more details. Link to comment Share on other sites More sharing options...
franxic Posted August 26, 2015 Author Share Posted August 26, 2015 Thank you!I will look into it as soon as I can, and hopefully report back soon. 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