Export chart data into a CSV file using Jasper Studio

Prerequisites : JasperStudio  

In this Blog we will learn how to export a chart data into a CSV file, when we try to export a chart into a csv it will show empty output because jasper will not support this functionality.For example below is the chart which developed by Jasper Studio and trying to export that chart in excel

HTML Output

Csv Export

So to overcome this follow below steps :

Step 1 : Create a Table with same dataset

Step 2 : Hide the Table in Html/Pdf,for this we need to set a property

<property name="net.sf.jasperreports.export.html.exclude.origin.band.2" value="summary"/>
<property name="net.sf.jasperreports.export.pdf.exclude.origin.band.2" value="summary"/>

Step 3 : Now download the CSV we can able to see the data

Thanks,
SatyaGopi.

Helical It Solutions

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download