Multi level grouping in a report

[cornedbeef007-groups]

I'm building an application to do entries in dog shows.
I have made my application able to do multiple shows at the same time.
I have Exhibitors, who have dogs, The dogs are entered into a Show in
a particular class

Exhibitors make payments.

I have a query which extracts exhibitor details, their entered dogs
with show and class details, and cheque(s) details. Some exhibitors
send one cheque for two shows, others send a cheque for each show,
others send a cheque per dog.

I need a report to print
For each Exhibitor,
all cheques for current shows,
Each show entered, sorted by date
Each dog entered, sorted by class

I have tried many permutations of grouping/sorting, and even tried a
subreport for cheques, but every exhibitor got EVERY cheque.

I've currently got
Grouping on Exhibitor ID, with Exhibitor name in the header
Grouping on cheque id with cheque details in the header
Grouping on Show date with show details in the header
Groupin on Dog Name, with dog details in the header.

I almost get what I want, but I get one set of cheque details, the
show entries, then I get the second cheque details, and the show
entries again.

I need all the cheques listed together, then the show entry details
once.

Can someone give me a clue on how to get my report to print my
"Exhibitor Receipt"?

 

[cornedbeef007-groups]

I'm building an application to do entries in dog shows.
I have made my application able to do multiple shows at the same time.
I have Exhibitors, who have dogs, The dogs are entered into a Show in
a particular class

Exhibitors make payments.

I have a query which extracts exhibitor details, their entered dogs
with show and class details, and cheque(s) details. Some exhibitors
send one cheque for two shows, others send a cheque for each show,
others send a cheque per dog.

I need a report to print
For each Exhibitor,
   all cheques for current shows,
Each show entered, sorted by date
      Each dog entered, sorted by class

I have tried many permutations of grouping/sorting, and even tried a
subreport for cheques, but every exhibitor got EVERY cheque.

I've currently got
Grouping on Exhibitor ID, with Exhibitor name in the header
   Grouping on cheque id with cheque details in the header
     Grouping on Show date  with show details in the header
       Groupin on Dog Name, with dog details in the header.

I almost get what I want, but I get one set of cheque details, the
show entries, then I get the second cheque details, and the show
entries again.

I need all the cheques listed together, then the show entry details
once.

Can someone give me a clue on how to get my report to print my
"Exhibitor Receipt"?

I've managed to do it with a subreport for the cheques in the exhibtor
id footer, placed a non-visible Exhibitor Id field on on the
subreport, and also on the main report, then linked master and child
fields.

 

[Access Developer]

If, instead of just describing your application at a high level, you had
provied specifics and details of the data you have and its organization into
tables, it is possible someone could either provide useful suggestions or
ask specific questions to proceed. If you'll start with the data, layout,
and relationships, someone is likely to respond to you.