Sorting Number Arrays in Crystal Reports | CLEARIFY

Sorting Number Arrays

There may be times that you want to re-arrange the order of numerical items you have collected in an array.  Here is how you progammitcally sort this:

1. Create a formula similar to the following:

// 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;
NumberVar Array Array_Name;
NumberVar counter1;
Numbervar counter2;
Numbervar temp;
Numbervar Array_Size := count(Array_Name);
for counter1 := Array_Size to 1 step -1 do
(
for counter2 := 1 to counter1 - 1 do
(
if Array_Name[ counter2] >
Array_Name[ counter2 + 1] then
(
temp := Array_Name[counter2];
Array_Name[counter2] :=
Array_Name[counter2 + 1];
Array_Name[counter2 + 1] := temp;
)
);
);

2. Replace the Array_Name variable with the variable name of your Array.

3. Insert the formula into a section in your report. Ensure that you insert the
formula in the section after the section that is used to populate your Array.