multi column reporting

[Patrick Stubbin]

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 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
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