multiple records within each record of a report

[kcatthegreat]

Okay, I know that was a confusing title, but what I'm trying to do is this; I have a database that uses checks to pay for invoices. Sometimes many invoices are paid with one check and sometimes many checks go to pay one invoices.

To resolve the many to many relationship between checks and invoices, I have a bridge table called tblCheck_Invoice.

I am making a report. It should list each check and all invoices associated with that check like this:

CHECK A
Invoice 1
Invoice 2
Invoice 3

CHECK B
Invoice 4
Invoice 5
Invoice 6

The problem is that, instead of doing that, it does this:

CHECK A
Invoice 1

CHECK A
Invoice 2

CHECK A
Invoice 3

CHECK B
Invoice 4

CHECK B
Invoice 5

CHECK B
Invoice 6

etc. etc. I tried making a subreport but that didn't work. Does anyone know how to do this?

 

[rjoubert]

Add a group for your CHECK value, put the Check ID into the group header, and leave the Invoice number in the report detail.