Culture in Report - Number Formats

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
customaware
Posts: 2392
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Culture in Report - Number Formats

Post by customaware »

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?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Culture in Report - Number Formats

Post by ACDC »

In the report writer, have you tried <<Object.Number,#.###,0>>
customaware
Posts: 2392
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Culture in Report - Number Formats

Post by customaware »

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
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Culture in Report - Number Formats

Post by Jaymer »

Screen Shot 2020-06-05 at 2.59.29 PM.png
Screen Shot 2020-06-05 at 2.59.29 PM.png (51.52 KiB) Viewed 6041 times
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
customaware
Posts: 2392
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Culture in Report - Number Formats

Post by customaware »

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....
Image
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Culture in Report - Number Formats

Post by tford »

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.
Tom - V8.8 build 3137 - MySql / PostGres
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Culture in Report - Number Formats

Post by aware_support »

This is a limitation that will be removed in the next version.
Aware IM Support Team
Post Reply