Report using Array fields from DB.

[rnd]

DB = SQL Server 7 / 2000 CR = 8.5

The DB table is storing everything in arrays for all datatypes. I have to report a multiple column report using different instances from each array. This could be from one table or another. Each selection is conditional. The layout would look like this:

COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5
-------------------------------------------------
Tab1.Fld2[4] Tab1.Fld5[7] Tab1.Fld8[3]
Date Number String

LOGIC:
I write a formula: IF Tab1.Index = 4 then Tab1.Fld2
I get the value for the first column for index7 and 15 other rows are empty(depicting the suppressed instances). The records multiply depending on the number of indices for each case. I can't suppress the other columns in a row since they involve another instance of the same or different field/index.
Another problem is the condition differs in certain columns for which the logic is like
IF TAB2.FIELD4 IS TRUE (OR = SOMEVALUE) THEN TAB1.FIELD3[2].
The above formulas are not real syntax. Just represent the logic.
Please help me with the structure of formula that would work.
Thanks.