Report only recognizes two sorts...

[arachnoid]

I am attempting to sort a report by state, cust# and due date; however, the report will only recognize the sort order for the first two groups, regardless of their order.

I have moved the groups up and down in sort priority and group order, but regardless of the grouping order it will still only sort by the first two groups.

Upon viewing the SQL, there is no Order By statement, which stumped me. I would simply add one, but one of my groups is a formula field and I'm not sure how to write the syntax for that group using the Crystal SQL.

Does anyone know what would cause this, or how to correct it?

Thanks,

 

[synapsevampire]

You can force sortation using Report->Sort Records

If you have 3 groups, then the report will sort by group 1, within that group 2, within that, group 3.

Perhaps you should supply example data and the results that you're getting (as well as the obvious Crystal version). It may be that there's some confusion about sortation rather than an error.

-k