Unsupported totals sort

[reshelman]

[updated:LAST EDITED ON Dec-09-02 AT 00:08 AM (EST)]Why can you not sort on a calculated field whose expression includes both a preprocessed total and a database field?____I^m using version 9 SQL.____Thanks,____Robert Eshelman__

[kfleming]

It is a internal restriction based upon the methods that R&R uses internally to build and select composite records.__The workaround is to export the field to DBF and then create a second report using that DBF as the master file. Since it is then an ordinary field, you can use it as a sort field.____Kathleen__R&R Support