Prerequisites: Jasper Server 6.4.0
In this blog we learn how to apply number formatting without using the pattern expression.
There is no number formatting for this column.
To change the text background color green if store state is OR else displays text color as red and also apply the number format to store_sales column.
For applying the above condition by using the markup property as styled, apply the pattern expression and updates the text field expression accordingly
The Following will be result-set
Even though applying the pattern expression to text field the number formatting is not done, to overcome this issue we have to use the string_format() conceprt in text expression, but also make sure that field should be an integer format means java.lang.Integer class
Final Output of the report:
Best Open Source Business Intelligence Software Helical Insight is Here
A Business Intelligence Framework
In case if you have any queries please get us at firstname.lastname@example.org
Helical IT Solutions Pvt Ltd