Sorting Text Arrays in Crystal Reports | CLEARIFY

Sorting Text Arrays

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 the
formula in the section after the section, which is used to populate your
Array.