multiple columns

  • Thread starter patrick stubbin via AccessMonster.com
  • Start date
P

patrick stubbin via AccessMonster.com

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

column1 column2
field1 field2 field3 field1 field2 field3
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx

field1 field2 field3 field1 field2 field3
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx
etc
the above just wont work for me, please any thoughts on how to get it to
work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multi column reporting 0
Row and Column Totals on a Report 1
reprots 3
report format 0
Totals on a Report 2
columns 0
reports 0
multi column 0

Top