Trouble with a sort

[FRED_EMMERICH_(Guest)]

I have 2 preprocessed totals, A & B. I have a calculated field called C, which is = A-B. I sort on C no problem.____Now I create calculated field D, which is C*factor (factor is a number in the master, different for each entity).____I want to sort on D, but D does not show up in the list of available field. What am i doing wrong? Both totals that go into this calculation are preprocessed.____Am using RR12.____thanks__Fred

[kfleming]

R&R does not let you sort on a calc field that includes a pre-processed total and a data field. This restriction should be listed in the help file/documentation.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

Is there any work around?____thanks__Fred

[kfleming]

The only workaround is to export the report to a dbf so that the total becomes a regular table field. The write a second report against the exported table. It sounds more complex than it really is and it will get you the desired result.____Kathleen__R&R Support