【Question】

I have the this data:

data = [{“car”:“clear”,“number”:[“12”,“13”,“14”,“21”]},{“car”:“noClear”,“number”:[“34”]}]

I want to show it in the report like this:

clear

12 13 14 21

noClear

34

【Answer】

You can create a standard 2D table by converting the sequences under number field into space-separated strings, and give the table to JasperReport for presentation. You can handle the report data source preparation in SPL (Structured Process Language) in simple code:

Final result:

A1: json Read in the Json data.

A2: Create a table sequence based on A1.

A3: Convert number field values into space-separated strings and generate a new table sequence based on the strings.

You can connect to esProc in JasperReport via JDBC and call the SPL script in the same way as calling a stored procedure. For detailed information, see How to Call an SPL Script in JasperReport.