Jump to content
Changes to the Jaspersoft community edition download ×

Excell Format cell in ireport


medang

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Exponential format? Do you mean scientific notation? If so this will happen because:

 

 

1) You haven't set the the desired element output pattern (eg. #,##0.00) in the source. Look under the "Text Field" tab in the element properties dialog box.

 

 

and/or

 

 

2) The element is not wide enough to display the full output, so excel automatically converts to scientific notation so that at least part of the number is readable. Try setting the element's width to a larger value

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...