Passing a List of the Top 10 Values from Main to Sub - How?

building reports crystal reports
1

I have a report that gives me a list of customers sorted by Time frame (A) and by Measure (D) and I need the Top 10 value to be passed to a sub report through a Parameter so it can generate a reduced result set. I am able to pass the first value but nothing else and the Parameter doesn’t see it. I have 3 arrays statements in the main report. The first one is in the report header and looks like this:


//Customer Array Reset
whileprintingrecords;

//Declaration of Array and variable for counting
global StringVar Array CustomerArray;
global NumberVar Customer_counter;

//Re-dimension of Array and initialization of variable
Customer_counter := 0;

The second one is below the first:


//Customer Array Accumulate
whileprintingrecords;

//Declaration of Array and variable for counting
global StringVar Array CustomerArray;
global NumberVar Customer_counter;

//Incrementing the variable for counting
Customer_counter := Customer_counter + 1;

//Reading values in the Array with the Array Index as variable value
CustomerArray[Customer_counter] := Database_field

And the third is in the report footer:


//Customer Array Append
whileprintingrecords;

//Declaration of Array and variable for counting
global StringVar Array CustomerArray;
global NumberVar Customer_counter;

//Using the Join Function to concatenate using delimiter
Redim CustomerArray[180];
Join (CustomerArray[1 to Customer_counter],",");

What am I doing wrong?

fknaut :us: (BOB member since 2005-08-04)

2

What section is your subreport in?

-Dell

hilfy :us: (BOB member since 2007-04-16)