Sorting Text Fields with Numbers

rbuser

Using: v10.07

In building our application, a major part of the application uses what I
will call a catalog number. These catalog numbers contain alpha and numerica
characters. So the result we need is for example,

1
2
3
3a
3b
1000
1001

In the Developer Express components we were able to successfully accomplish
the sorting we needed on the various grids with an event handler
"TcxCustomDataController.OnCompare". (The OnCompare event occurs when values
from two records are compared when sorting.) No modification db tables was
required to achieve the sorting required.

Does the report writer contain a similar option so that we can avoid
changing the database? If so, what is the function and where do we find it?

Here is to hoping!

Jack Wilson
jwilson@nwsoftware.com
www.nwsoftware.com

nardmoseley

ReportBuilder traverses the dataset using calls to First, Next, Prior, etc.
It does not have any ability to sort the data.

- one option might be to use a ClientDataSet, I think it enables an index to
be defined. So perhaps define a calculated field and then an index on the
calc field. Just an idea, I have not tried it and not sure if that helps
you.

- another option is to try using the RB TppJITPipeline to access the data
stored in the Dev Express components.

Database --> Dev Express --> JITPipeline --Report





--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com