iReport Jasper export to Excel
We are trying to use JasperReport from our Java based web application. We are using JDBC Data source. And Report is rendered through a Java Servlet.
To create the report xml file we are using iReport tool.
But we are facing problem while exporting report to Excel format.We are getting one field in exponential format. We tried using TO_CHAR in SQL query, but not able to resolve problem.
For eg. we have SQL query as follows :
select column1 from xyz
column1 is containing values in format 11581000029014400
but when report is exported to excel, value in cell is shown in exponential format.(Formula bar in excel show 11581000029014400 ).
Kindly provide a solution to remove exponential format, and show value in proper number format in excel report
Thanks in advance,