User clicks "Group - Reports - Intercompany Report". User chooses selection, and clicks "Run Report". However, the formatting looks 'wrong' (the numbers have spaces in them, instead of the expected commas (,)
If user clicks "Print" then the screen "Intercompany Report print preview" appears. Again, the formatting looks 'wrong' (the numbers have spaces in them, instead of the expected commas (,)
* If user clicks "Open spreadsheet" then the report opens inside Excel. Again the formatting looks 'wrong'.
There are other possible causes for standard reports formatting looking incorrect.
- For example, see separate IBM Technote #1633637.
This Technote specifically relates to the scenario where the cause is a code production problem (defect PM89887) in Controller.
- This defect is only triggered when the client device (e.g. end user's PC or end user's Windows user profile on Citrix/Terminal server) has been configured so that its regional settings have a 'space' configured to be the thousand separator.
On the client PC, inside "Control Panel" the user can launch the "Region and Language". Inside the "Formats" tab, the user can choose how their software displays its formatting.
- By default, many regions (e.g. English UK) have the thousand separator set to a comma (,)
- However, some regions (e.g. "Norwegian, Bokmal") have a different separator (e.g. "space"):
Resolving the problem
Upgrade to later version of Controller (when available) which contains a fix for this issue.
- TIP: to be automatically notified when this version is available, subscribe to APAR PM89887.
Modify the regional settings of the 'bad' end user(s) so that the "Region and Language" settings are configured to display the same way that the end user wants their reports to look.
- Logon to the client device as the same 'bad' Windows user who has the problem
- Open "Control Panel"
- Open the regional settings (for most modern versions of Windows, this is "Clock, Language, and Region" - "Region and Language")
- Inside the "Formats" tab, change the "Format" to a region (e.g. "English (United Kingdom)") whose format matches what the user wants to see.
- Save changes and test.