Home Datapipelines

Sorting Text Fields with Numbers

edited March 2008 in Datapipelines
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

Comments

  • edited March 2008

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.