Array Create

[radhak]

Kathleen,____I am able to create the array as I had wanted. But the moment I sort the master file the array starts getting double entry.____I am using the following calculation____IIF(COUNTER=1,SCOD+" ",ARRAY1+" "+SCOD)____SCOD = 1 2 3 4 5 ____The result I get is as follows:____ARRAY1= 1 2 3 4 5 .....____But if I sort the master file the array behaves in a funny way as indicated below:____ARRAY1= 1 2 2 3 3 4 4 5 5 .......____The meonet I take out the sort everything comes back to normal____I need this function working quickly as people are waiting for this report. ____I would appreciate if any one could shed light on why this happening and how to get rid of this double results____Thank you all in advance

[kfleming]

Is COUNTER a total field? What is its accumulation frequency?____Kathleen__R&R Support

[radhak]

I count the records with RECNO() and the total it and reset on group change. The create another calculation which looks like:____ARRAY1= IIF(COUNTER=1,SCOD+" ",ARRAY1+SCOD+" ")____The array works.____Now I find that if you have more than one scan the number of occurance also increases accordingly. I mean duplicates/triplicates____Kathleen, will I be able to send you the .rrw file so that you could look at it and give me a way out?____Thanks in Advance.

[kfleming]

Send the report to me at livesupport@livewarepub.com and let me know what the expected result should be.____Kathleen__R&R Support