IBM Support

Number grouping (thousand separator) always set to 'comma' (,) - for example cannot be changed to 'space' - when using new 'Embedded Report Library' (IBM Cognos Controller Reports) standard report engine (via "ccrReports"), caused by APAR PH23266

Troubleshooting


Problem

Customer has decided to use the new (since version 10.4.2) standard report engine 'Embedded Report Library'.
  • In other words, they have configured 'web.config' to use "ccrReports" (see separate IBM Technote #1489047).
Customer is based in a geography (for example Sweden) where the 'thousand separator' (for numbers) is traditionally something other than comma.
  • For example in Sweden it is a 'space' ( )
Therefore, to achieve this, the customer modified the regional settings (of both the client device and the Controller application server) to the appropriate value (for example "Swedish (Sweden)")
Afterwards, unfortunately, when standard reports are run, all numbers appear with comma separating groups of numbers (for example:  1,234,567) instead of the expected: 1 234 567

Symptom

For example, imagine a scenario where the user clicks 'Reports - Ad Hoc' and then runs a report.
  
When using new 'Embedded Report Library':
image 2521
...or zoomed in:
image 2525
  
Compare this to when using Cognos Analytics as the report server:
image 2527
As you can see (above) Cognos Analytics groups the numbers using a space separator, when the regional settings tell it to use a space (for example 'Swedish (Sweden)'.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
09 May 2025

UID

ibm15736855