I have an app which requires changing Culture so that numerical values display as #.###,0 rather than #,###.0
I have changed the Culture in the Locale and everywhere in the app it works.... well, nearly everywhere.
I cannot get a Report to display the numerical values in the right format. I have tried casting the values with @'#.###,0' and also tried AS_STRING(Number,'#.###,0')
No joy.
Has anyone come across this and found a solution please?
Culture in Report - Number Formats
-
- Posts: 2425
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Culture in Report - Number Formats
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Culture in Report - Number Formats
In the report writer, have you tried <<Object.Number,#.###,0>>
-
- Posts: 2425
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Culture in Report - Number Formats
That syntax is not accepted. Syntax error
<<Object.Number,'#.###,0'>> is not accepted - syntax error
<<Object.Number@#.###,0>> is accepted but displays nothing
<<Object.Number@'#.###,0'>>is accepted but displays nothing
<<Object.Number,'#.###,0'>> is not accepted - syntax error
<<Object.Number@#.###,0>> is accepted but displays nothing
<<Object.Number@'#.###,0'>>is accepted but displays nothing
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Culture in Report - Number Formats
from inside the report writer, both of these work
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 2425
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Culture in Report - Number Formats
Try swapping the . and the , Jaymer.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Culture in Report - Number Formats
It sure sounds like there is no easy formula solution to this, Mark. Looks like Aware is confused by the , and seeing it as a delimiter.
I know it would be clunky, but as a work around could you store the formatted value in a text field and display it that way. If it's an attribute or two, it seems that might work. If it's a bunch of attributes, I'm sure that would be a pain.
I know it would be clunky, but as a work around could you store the formatted value in a text field and display it that way. If it's an attribute or two, it seems that might work. If it's a bunch of attributes, I'm sure that would be a pain.
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Culture in Report - Number Formats
This is a limitation that will be removed in the next version.
Aware IM Support Team