Jimmy,
Fascinating :) How could you handle all these.
"*THIS REPORT HAS FIELDS ACBUNDLE2, ACBUNDLE4, ACBUNDLE6, ACBUNDLE7......." ???
Fields or memvar ? Reports work with tables, cursors. If at the same time there is a field named ie: ACBUNDLE2 in current workarea table.field takes precendence unless you precede it with "m.".
As far as I understand each query is expected to return one element (or do you just use its first element). Also as I understand they absolutely return at least one element (otherwise type error with .. = bunlen12 ... ). This would mean you could combine the whole SQL into one.
select ;
data1.bundle+data2.bundle...+data8.bundle as acBundle, data1.length ;
from data1, data2.... ;
where data1.grade + data1.siz = data2.grade + data2.siz ;
and data2.grade + data2.siz = data3.grade + data3.siz ;
and .... ;
and data7.grade + data7.siz = data8.grade + data8.siz ;
and data1.grade = gdValue and data1.siz = szValue ;
order by 2 ;
into cursor myCursor
grade + siz might need conversion depending on their type. Report would then be based on myCursor.
Cetin