I have a file that I am trying to display in a grid.
The file has several columns that have numeric content, but are in alpha columns.
(This is probably because many years ago this file was an after-the-fact extract from a report file.)
I have By-Column searching set on this grid.
I usually want my numeric columns to have a numeric-style <, >, = search paradigm.
So I took these numbers-in-alpha columns and wrote something like this in the data source sql select:
Select decimal(colname, 7, 2) as colname, ...
These columns do not have a Search option in their dropdowns at all, while all the other more native columns around them do.
Is this the right technique or should I do something else?
Bob
The file has several columns that have numeric content, but are in alpha columns.
(This is probably because many years ago this file was an after-the-fact extract from a report file.)
I have By-Column searching set on this grid.
I usually want my numeric columns to have a numeric-style <, >, = search paradigm.
So I took these numbers-in-alpha columns and wrote something like this in the data source sql select:
Select decimal(colname, 7, 2) as colname, ...
These columns do not have a Search option in their dropdowns at all, while all the other more native columns around them do.
Is this the right technique or should I do something else?
Bob
Comment