I have a money column that I would like to sort on and display in the grid view with formatting ($###,###,##0.00)
Format String in Field Preferences seems to have no effect.*
I can add it as a formatted column from a view, but then the sorting is off because it gets converted to nvarchar.
Can there be a way for dbFront to sort on raw data but display a formatted string?
*As an aside - when are Format Strings supposed to work? I tried a few strings on integer and decimal columns and nothing had any effect.