osdir.com
mailing list archive

Subject: Currency format in Excel report - msg#00007

List: java.jasperreports.general

Date: Prev Next Index Thread: Prev Next Index

Hi, is there any chance to set in report, Excel cell format to currency?
Thanks in advance.
--
View this message in context:
http://www.nabble.com/Currency-format-in-Excel-report-tf4668856.html#a13337263
Sent from the jasperreports-questions mailing list archive at Nabble.com.


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/


Was this page helpful?
Yes No
Thread at a glance:

Previous Message by Date: click to view message preview

Decimal Formating in Excel jasper report

While generating report , their is inconsistencies of how the quantity, original cost, purchase price We are sending data formatted manner only , but while rendering the data to Excel format. So different senarios are : Instead of 333.00 its displaying 333 Instead of 333.99 its displaying 333.99 Instead of 3,333.00 its displaying 3,333.00 Can someone pls suggest me what to do ...? -- View this message in context: http://www.nabble.com/Decimal-Formating-in-Excel-jasper-report-tf4669469.html#a13338834 Sent from the jasperreports-questions mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/

Next Message by Date: click to view message preview

Re: Decimal Formating in Excel jasper report

You can convert the number type double into a formatted string with this library: - java.text.DecimalFormat                service formatSample:double numero = 12.5 new java.text.DecimalFormat("#,##0").format(numero) --->  12  new java.text.DecimalFormat("#,##0.00").format(numero) ---> 12.50That's all.See you.pd: my english is a little, sorry about that2007/10/22, diptypatil < diptypatil-/E1597aS9LQAvxtiuMwx3w@xxxxxxxxxxxxxxxx>:While generating report , their is inconsistencies of how the quantity, original cost, purchase priceWe are sending data formatted manner only , but while rendering the data toExcel format.So different senarios are :Instead of 333.00 its displaying 333Instead of  333.99 its displaying  333.99Instead of  3,333.00 its displaying  3,333.00Can someone pls suggest me what to do ...?--View this message in context: http://www.nabble.com/Decimal-Formating-in-Excel-jasper-report-tf4669469.html#a13338834Sent from the jasperreports-questions mailing list archive at Nabble.com.------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc.Still grepping through log files to find problems?  Stop.Now Search log events and configuration files using AJAX and a browser.Download your FREE copy of Splunk now >> http://get.splunk.com/_______________________________________________jasperreports-questions mailing listjasperreports-questions-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/jasperreports-questions ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/_______________________________________________ jasperreports-questions mailing list jasperreports-questions-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/jasperreports-questions

Previous Message by Thread: click to view message preview

Decimal Formating in Excel jasper report

While generating report , their is inconsistencies of how the quantity, original cost, purchase price We are sending data formatted manner only , but while rendering the data to Excel format. So different senarios are : Instead of 333.00 its displaying 333 Instead of 333.99 its displaying 333.99 Instead of 3,333.00 its displaying 3,333.00 Can someone pls suggest me what to do ...? -- View this message in context: http://www.nabble.com/Decimal-Formating-in-Excel-jasper-report-tf4669469.html#a13338834 Sent from the jasperreports-questions mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/

Next Message by Thread: click to view message preview

2 charts in one report from 2 db tables(ireport)

hi, i have a requirement where i need to display 2 charts(pie and bar)in a single report side by side whose data come from different tables from the database.how can i do this using jasperreports and ireport.any help would be appreciated.....thanks in advance. -- View this message in context: http://www.nabble.com/2-charts-in-one-report-from-2-db-tables%28ireport%29-tf4698878.html#a13432434 Sent from the jasperreports-questions mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/
Sign up for updates to this mailing list. email:
Loading Comments...
Home | News | Patents | Sitemap | FAQ | advertise

Advertising by