Right click on the report and choose “Report Code”. We’re going to start by working “Opening of ...” section of the report code. To begin with let’s create a “Dynamic Array”. Enter the following code.
Let’s go over the variables that we just created. Of course we know the first variable is our array. Our query needs a field named “FullName” and that’s it, so we’re going to take the entire result of the query and pass it into the array with a procedure we’ll write in a minute.
gnLeft & gnRight are integers that allow us to keep up with which elements of the array we will be accessing for each column. In this example as you’ve probably figured out we’re only going to have two columns, hence the “gnLEFT” and “gnRIGHT”.
I & j are simply holders where we will store the count of records found in the query and the array. gnPrintCnt is where we will track the total number of records that have been printed.
While we’re still in the “Opening” section of the report, let’s go ahead and execute our query and read it into the array.
garrMyData is array dynamic
gnLeft is int
gnRight is int = 25
i,j is int
gnPrintCnt is int