medang Posted January 24, 2007 Share Posted January 24, 2007 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 More sharing options...
jmurray Posted January 30, 2007 Share Posted January 30, 2007 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 More sharing options...
medang Posted February 6, 2007 Author Share Posted February 6, 2007 hi jmurray...i tried...but did not work... fyi, the exponent number which is display at excell actually in string format...so, there's any solution that might help me...hope to hear from u soon... anyway thanks.. Link to comment Share on other sites More sharing options...
medang Posted February 6, 2007 Author Share Posted February 6, 2007 extra info the exponent number (e.g : 6.30501E+14)the real number :630501045892540 Link to comment Share on other sites More sharing options...
jmurray Posted February 7, 2007 Share Posted February 7, 2007 It's not something you can fix in iReport - Excel is apply "General" format rules. The best thing to do is to change the format of the cells in Excel to "Number" after the report is filled. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now