guigui94

Is there a solution to get only 1 field : sections as a Json array with objets that are made of 3 attributes : "id" (string), "property-One" (boolean) and fields (json array of json objects) and then use expressions inside the report to show specific values Best regards, Guillaume

Hi I wonder how i can achieve this : - use of a remote JSON file (WS call) - no fields configuration since i do not want to loop over them in my report - search and access json nested objects with jsonql to fill dedicated report area but directly in the report example: in my report i should show - the parcel ID => as text - the value of the "value" field fo the rule object found after filtering on "key" == "mindist" => as text - populate a table wilth th adresses list here is a sample of my json, always one signe "main" root : { "main": { "parcel": { "id": "10AB01" }, "rules": [ { "key": "maxheight", "value": "20m" }, { "key": "mindist", "value": "2m" } ], "addresses": [ { "address": "1 King Road", "key": "park", "value": "no" }, { "address": "2 queen alley", "key": "park", "value": "yes" } ] }}[/code]thanks Guillaume

Hi, here is my json structure : { "main": { "parcel": { "id": "10AB01" }, "rules": [ { "key": "maxheight", "value": "20m" }, { "key": "mindist", "value": "2m" } ], "addresses": [ { "address": "1 King Road", "key": "park", "value": "no" }, { "address": "2 queen alley", "key": "park", "value": "yes" } ] }}[/code]My report (launched from librairy, not JasperServer) should have a fixed content (not looping on sub list, juste acces the "main" object) and show : - information from the parcel object (ex : parcel ID in the report Title section or at the top of the Detail section) - key/values from the rules list : checkboxes checked or not (using image) depending on key/values found in the "rules" json attribute ex: according to the the above json example, 3 checkboxes + text in the report should be shown as follow : key "mindist" is in the liste so : checked.png + "Minimum distance to road should be applied to parcel : " + value form key = mindist key "maxheight" is in the list so : checked.png + "Maximum build height sould be : " + value for key = maxheight key "housecolor" is not in the liste so : unchecked.png + "House color should be : " + "" - use addresses in sub tables. I did set the JSON data adaptator on the "Main" and i get 3 fields in my report : parcel, rules, addresses but i can't find how i should configure the fields and use them as json in the report to get my result. thanks for your help. Best regards, Guillaume

juste use a classic image component instead of the google map one.

Now that it's WE here i realize that my proxy setting was not set ... WMS works fine as image source.

dear all, I wonder if instead of the default map component i can use a WMS url to define an image source in iReport ? here is an example of WMS that show an image as jpeg file : http://www.gebco.net/data_and_products/gebco_web_services/web_map_service/mapserv?request=getmap&service=wms&BBOX=-90,30,5,65&srs=EPSG:4326&format=image/jpeg&layers=gebco_08_grid&width=900&height=600&version=1.1.1 I did try serveral options i failed. the error i got : Error filling print... net.sf.jasperreports.engine.JRException: Error opening input stream from URL : http://www.gebco.net/data_and_products/gebco_web_services/web_map_service/mapserv?request=getmap&service=wms&BBOX=-90,30,5,65&srs=EPSG:4326&format=image/jpeg&layers=gebco_08_grid&width=300&height=150&version=1.1.1net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL : http://www.gebco.net/data_and_products/gebco_web_services/web_map_service/mapserv?request=getmap&service=wms&BBOX=-90,30,5,65&srs=EPSG:4326&format=image/jpeg&layers=gebco_08_grid&width=300&height=150&version=1.1.1 ... Caused by: net.sf.jasperreports.engine.JRException: Error opening input stream from URL : http://www.gebco.net/data_and_products/gebco_web_services/web_map_service/mapserv?request=getmap&service=wms&BBOX=-90,30,5,65&srs=EPSG:4326&format=image/jpeg&layers=gebco_08_grid&width=300&height=150&version=1.1.1 at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:317) ... Caused by: java.net.ConnectException: Connection timed out: connect but in firefox the URL is loaded very fastly si the URL is OK anyone can help me ? thanks Guillaume