Skip to Content
0
Former Member
Apr 16, 2009 at 05:34 PM

How to assigned array index position to database field

108 Views

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.