iReport Jasper export to Excel

[2006 IR Open Discussion]

By: infotech3i - infotech3i

iReport Jasper export to Excel

2006-08-17 22:43

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,