We have a doubt ..
How to set currency pattern in iReport .On the generated excel sheet default existing values as well as on user updation positive value should be represented as $ xxxxxx.xxx ,negative value ($xxxxxx.xxx) in red.
We tried the below pattern
This works for the below values :
If we remove 1000's seperator it works for thousand values, it fails for lakh values.Why?
i.e.,For bigger values the color change is not happening on the Excel sheet
Please guide us with your valuable suggestions at the earliest.
Avoid my previous reply - formatted one i'm pasting here...
Please find a detailed description about the issue faced as below..
Revised Budget / Encumber
$0.00 (black) I
n iReport tool custom pattern that we have specified for Revised Budget text field placed in detail band is as below :
We require a color change to red if user updates the field value as a negative number and if user enters positive input the value should be in black as above. We use XML file as Data source here , When the value is in lakhs ,its not displayed in excel sheet instead we get ‘[Red] ‘ as in 6th row .What is the reson behind?
Any ways to set this color change option to the mentioned field? Requirement : Positive values should be represented in black color as in 7th row,negative value shoud be represented in red color along with braces as in 1-5 rows.
Any mistake in the way we are setting the patter?
Waiting for your reply at the earliest..