Page 1 of 1
Problem with sorting on fields
Posted: Tue Jul 08, 2008 3:10 pm
by stevengeus
Can someone help me?____I want to sort records in my report based on this formula: iif(recno()=1,1,iif(left(Description,3)="---",Sort1+1,Sort1))____The problem is that the value of Sort1 changes during the report____I also tried to make a total field of this, but without succes... ______Is there a solution for my problem?
=> RE: Problem with sorting on fields
Posted: Tue Jul 08, 2008 3:11 pm
by kfleming
What do you want the order of the records to be?____Kathleen__R&R Support
==> RE: Problem with sorting on fields
Posted: Wed Jul 09, 2008 7:17 am
by stevengeus
Thank you for your fast reply!____Example:____---> Document ABC of 2008/07/08__Article ABC__Article CDE__Article EGG____---> Document CDE of 2008/07/15__Article FHR__Article PKH__Article KLM______In the report I want first to sort on my formula and second on a field ^article^__The meaning is that I can sort on the field ^Article^ within two times ^--->^, therefore I count the times ^---^ on my report____If you need more explanation, please let me know
===> RE: Problem with sorting on fields
Posted: Wed Jul 09, 2008 7:29 am
by kfleming
Can you simply use two sort fields.__The first would be a calculated field with the expression:____iif(left(Description,3)="---",subs(Description,15,3),"")____and the second would be:__iif(Description="Article*",subs(Description,9,3),")______Kathleen__R&R Support