There may be times that you want to re-arrange the order of items you have collected in an array. Here is how you progammitcally sort this:
1. Create a new formula called @Sort_Array.
2. Cut and paste the following formula into the formula editor:
// This formula tests to see if the element of the Array//is greater than the next element.//If the current element is greater than the next element,//their positions are switched using another variable//to temporarily store the value.WhilePrintingRecords;Stringvar Array Array_Name;NumberVar counter1;Numbervar counter2;Stringvar temp;Numbervar Array_Size := count(Array_Name);for counter1 := Array_Size to 1 step -1 do(for counter2 := 1 to counter1 - 1 do(if Strcmp( Array_Name[ counter2],Array_Name[ counter2 + 1]) > 0 then(temp := Array_Name[counter2];Array_Name[counter2] :=Array_Name[counter2 + 1];Array_Name[counter2 + 1] := temp;)););
3. Replace the Array_Name variable with the variable name of your Array.
4. Insert the formula into a section in your report. Ensure that you insert theformula in the section after the section, which is used to populate yourArray.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/229/sorting-arrays-text