specified sort order in matrix column

i had a column that had data that needed to be sorted in a specified order. (Crystal reports has a specified order choice for sort order)

i created a calculated field (on the data tab, then its available to choice from) for the column that i needed to specify the sort order. if the data was less than and greater than i assigned numbers to it. for example

1-5 assigned 1, 6-15 assigned 2, 16-30 assigned 3, etc.

then i went to the matrix column (edit group...) and used an expression

iif(calculated column = 1, "1-5", iif(calculated column = 2, "6-15", etc...))

i also added the same expression to the column.

this provided me with my specified sort order that i needed.

good luck, hope this helps you out.

chuck

[798 byte] By [chuckcycles] at [2007-12-19]