Prerequisites: Jasper Server 6.4.0
Database: Foodmart
In this blog we learn how to apply number formatting without using the pattern expression.
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
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
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
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:
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
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 support@helicaltech.com
Thanks,
Koyalwar Neha
Helical IT Solutions Pvt Ltd