Here is the sample data of my report.
Run# Note1 Note2 Note1 ArrayIndex Note2 ArrayIndex
101 CR Work 1 2
102 Work ER 2 3
103 ER Test 3 4
104 ER CR 3 1
104 Work 2
Page Footer: 1. CR 2. Work 3.ER 4.Test
I have to load distinct values of note1 and note2 in to array and assigned the array index of that note1 and note2 values and on the page footer i have to print distinct note1 and note2. would like to see at the page footer like above. I allready figer out how to load the distinct note1 and note2 values in array but i am not able to print the Not1Arrayindex and Note2Arrayindex value in the report. I am not sure how to print out the arrayindex values based on the array value.
Thanks for your help.