I have a sub query that is the underlying input for a sub report imbedded in
the main body of a report.  The query itself returns data that has multiple
instances of some fields, (ie duplicate value for some fields in a record but
not all fields).
I have created the sub report with the headings for each field and the data
fields in the 'detail' section, I wish to ensure that each set of records
that are grouped by the first field appear together in a column as a group
and then then next group displayed in the next field across and so on.

No amount of fiddling with the newrowcol detail or page setup allows me to
get it right. it is proving frustrating.  the one time i got it to work i had
it set up as printed down then across, but this would not work when imbedded
into the main report due to the page set of the sub report and that of main
report being different i think.  I hide duplicate values of the first field

included below is example of how it should  appear, but i just cant get it to

field1     field2    field3        field1     field2    field3    
 
xxxxx     xxxxx    xxxxx         xxxxx     xxxxx    xxxxx        
           xxxxx     xxxxx                     xxxxx    xxxxx              
           xxxxx     xxxxx                     xxxxx    xxxxx

xxxxx     xxxxx    xxxxx         xxxxx     xxxxx    xxxxx      
           xxxxx     xxxxx                     xxxxx    xxxxx              
           xxxxx     xxxxx                     xxxxx    xxxxx

the above just wont work  for me, please any thoughts on how to get it to work