Forum Discussion
- RobbSalzmannValued Contributor II
Could you try formatting the number in your sql query?
SELECT FORMAT(SomeNumericColumn,'#,0.00') from SOME_TABLE
- RandyThompsonNew Contributor III
I tried that and it didn't work. Table View seems to be ignoring the SQL formatting and applying their formatting based on the table view column definition.
Randy, you will have to get rid of the column format and use the populate from data table option with the keep format from data boolean.
- RandyThompsonNew Contributor III
Thanks, Celvin. Unfortunately I can't find any documentation on this. Can you share a snippet of code of how to use the populate from data table. Thanks.
- JackLacavaHonored Contributor
Didn't test this but it should work.
' assuming yourDataTable will have been obtained already Dim includeColHeaderRow as Boolean = True Dim useDataTypes as Boolean = True ' try switching this on/off to compare results args.TableView.PopulateFromDataTable(dataTable, includeColHeaderRow, useDataTypes) return args.TableView
Related Content
- 3 months ago
- 2 years ago
- 2 years ago