Decimal number format in AdHoc Views displaying incorrectly for resources with English(non US) locale after JasperSoft 8.1.1 upgrade.
search cancel

Decimal number format in AdHoc Views displaying incorrectly for resources with English(non US) locale after JasperSoft 8.1.1 upgrade.

book

Article ID: 264924

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

After the upgrade from Jaspsersoft 7.8 to 8.1.1, the number formats have changed in AdHoc views 

Steps to Reproduce: 

  1. Login to clarity with a user who has access to Advance Reporting
  2. In Clarity set a resource to have the English(Australia) locale
  3. Create an AdHoc View with any domain which has financial attributes (e.g Rows: Investment Name, Plan Transaction Class. Columns: Fiscal Month, Actual COst, Plan Cost)  

Expected Results: Numeric formatted results should be displayed in format 999,999.99

Actual Results: Numeric results are formatted with . and , transposed - 999.999,00

Workaround: 
Export the data in any format like CSV, Excel, PDF and format is ok as expected

 

Environment

Release : Jaspersoft 8.1.1 with any supported & compatible version of Clarity and non US locale, i.e. Australia

Cause

Tibco has confirmed this as defect JS-67531 and Broadcom is tracking this under DE69667

Resolution

DE69667 - Issue is resolved with JasperSoft 8.1.1 Patch 1.

Additional Information

Issues Fixed in Jaspersoft 8.1.1 Patch 1