Sorting by a calculated field

[Rio38]

Is there any way to sort by a calculated field other then creating temp-tables? I have a report that calculates Days Open, but only does this right before teh DISPLAY block. They want the report sorted by Days Open. With all of the toalling and summarizing going on in the report, I am afraid to create a temp-table to stir the pot.

 

[mpowell_esq]

Lets look at this logically. Is there anyway to sort a calculated field without using a buffer (temp table). How can U sort something without processing a result first. For sorting purposes. An array of numbers, the calculated fields can simply be compared against each other without applying processing.A1 (calculated field) * A11 (calculated field) = productB1 (calculated field) * B11 (calculated field) = product...IF values on the top row (A) are greater than the values on the other row (B,C...) then the product of that row will be greater than the others so that becomes sorted to the greatest value (top) of outputs.Follow the iteration through the rows (A,B,C) this is using a "bubble sort" process.