Hi all,



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,

Hi, I have the same problem as you, I think.
In my opinion you should change pattern in properties of this field, but then value could disappear from excel, then you should resize field on the report.
but then value will be detect as string and that is my problem, how to make it not be string and have format for example 11 581 000 029 014 400

p.s. sorry about my English