Hi,
Jasper is a great tool when you want to pivot the data. (In Postgres it would take ages)
Is there an option to create a chart based on the pivoted data in the crosstab?
Or to start from the raw data and pivot it in Jasper and have the output as a chart.
Thanks a lot!
1 Answer:
I fear the answer is no. You can 't access the crosstab variables outside the crosstab. Would be a nice feature though (eg. for calculating running totals based on calculated crosstab cells).
See: http://stackoverflow.com/questions/11715857/ireports-creating-charts-usi...
"As per my understanding for reporting with iReports, it is not possible to use those variables that are defined in the crosstab in charts. Crosstab is a seperated component from charts. All the variable that are defined in the crosstab are defined in the scope of the Crosstab only."