Create Jasper Chart based on data in Crosstab

[elena03elena]

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!

[clearfacts]

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-using-crosstab-total-variables

"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."