Number Format without Using the Pattern Expression for Text Box

Posted on by By admin, in Jaspersoft | 0

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.

Click Here to Free Download

Pattern Expression store info

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

Text Field

Expression Editor

The Following will be result-set

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Lets Register For Live Demo

Number of rows per page

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

Integer format

Final Output of the report:

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Get your 30 Days Trail Version

Final Output

logo

Best Open Source Business Intelligence Software Helical Insight is Here

logo

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

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments