How to fill report using JSON datasource without getting null values?

by

From JasperReports – JSON Data Source Sample (version 6.4.3)

The built-in JSON query executer (see the JsonQueryExecuter class) is a tool that uses the query string to produce a JsonDataSource instance, based on specific built-in parameters (or equivalent report properties). This query executer is registered via JsonQueryExecuterFactory factory class.
In order to prepare the data source, the JSON query executer looks for the JSON_INPUT_STREAM parameter that contains the JSON source objects in the form of an java.io.InputStream. If no JSON_INPUT_STREAM parameter is provided, then the query executer looks for the alternate net.sf.jasperreports.json.source String parameter or report property that stores the path to the location of the JSON source file.
JsonQueryExecuter runs the query over the input source and stores the result in an in-memory JsonDataSource object.

So if you do not want to use:

<property name="net.sf.jasperreports.json.source" value="emp.json"/>

You need to pass the file as java.io.InputStream in the parameter JSON_INPUT_STREAM

Hence you are currently passing it as datasource you should try something like this

params.put(JsonQueryExecuterFactory.JSON_INPUT_STREAM, new FileInputStream(file));
JasperFillManager.fillReportToFile(jasperReport, params);

If you instead like to use the new JsonQLQueryExecuterFactory JSONQL Data Source

params.put(JsonQLQueryExecuterFactory.JSON_INPUT_STREAM, new FileInputStream(file));
JasperFillManager.fillReportToFile(jasperReport, params);

More Related Contents:

  1. “Expected BEGIN_OBJECT but was STRING at line 1 column 1”
  2. Gson: How to exclude specific fields from Serialization without annotations
  3. JSON Array iteration in Android/Java
  4. How should I escape strings in JSON?
  5. Ignoring new fields on JSON objects using Jackson [duplicate]
  6. Difference between JSONObject and JSONArray
  7. Mapping PostgreSQL JSON column to a Hibernate entity property
  8. How to parse json parsing Using GSON in android
  9. How to show/hide a column at runtime?
  10. Jackson Vs. Gson [closed]
  11. Serializing with Jackson (JSON) – getting “No serializer found”?
  12. Spring boot @ResponseBody doesn’t serialize entity id
  13. Convert JSON String to Pretty Print JSON output using Jackson
  14. Sending a JSON HTTP POST request from Android
  15. How to decode JSON with unknown field using Gson?
  16. Why when a constructor is annotated with @JsonCreator, its arguments must be annotated with @JsonProperty?
  17. Parsing JSON string in Java
  18. How can I test if my font is rendered correctly in pdf?
  19. How do I obtain the Jackson ObjectMapper in use by Spring 4.1?
  20. How to create JSON Object using String?
  21. how to parse a huge JSON file without loading it in memory
  22. How do I use Google’s Gson API to deserialize JSON properly?
  23. How to map a map JSON column to Java Object with JPA
  24. How to compare JSON documents and return the differences with Jackson or Gson?
  25. Custom Jackson Serializer for a specific type in a particular class
  26. Using a generic type with Gson
  27. Using Gson with Interface Types
  28. Problem with Json plugin in Struts 2
  29. Jackson Serialize Instant to Nanosecond Issue
  30. How to deserialize JSON into flat, Map-like structure?

Leave a Comment