Strange spaces / formatting when running "Group - Reports - Intercompany Report" due to Regional Settings
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 Controller 10.2 or later.
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.
The exact steps will vary, depending on the operating system of the client device.
- The following steps are based on Windows 7.
1. Logon to the client device as the same 'bad' Windows user who has the problem
3. Open the regional settings. For Windows 7, this means:
- First click "Clock, Language, and Region"
- Then click "Region and Language"
5. Save changes and test.