jsonql | extended version of JSONPath with additional data | JSON Processing library

Defining a sort field will result in an in memory data source being used for the report, which means that $P{REPORT_DATA_SOURCE} is no longer the original JsonQLDataSource object.

Because of that, the data source expression ((net.sf.jasperreports.engine.data.JsonQLDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("suppliers") fails.

The solution is to use the SUB_DATA_SOURCE builtin function instead of JsonQLDataSource.subDataSource. The expression will look like this:

Thanks to Alex K answer in comments! He gave me the key, and it's about the font. For any reason if I don't define any font for my textfield the space between them are random. So, fixed adding this:

I was able to get total for row columns by defining group name in the data set used by crosstab.

Below is the final layout

Below is the modified jrxml notice the data set XTabDS has a group tag for id.

Instead of passing the data input stream to the fillReport() method, try passing it through in the parameter map instead:

In your list's textField you could set the evaluation time to something like Page or Report and display it only for the first record, something like so:

You need to make use of crosstabParameters in order to pass data from the enclosing report, like so:

There is an invalid field mapping: weekStartDate to java.lang.String[], that is not supported in JSONQL.

Instead you could have this subDataset expression:

Your subDataset should have no query, like this: