I've got a subreport in my main report and if I could have the subreport have a subreport I wouldn't have a problem. So at this stage Im hoping I can get what I want by using some type of grouping.

So in my subreport I've got headings in the report header then fields in the details section, what I need is the multiple lines associated to each of the lines in my details section to be displayed... How do I get this effect without using a subreport?

Excellent... Well here goes:

I Have two tables. CTIL and TILA tables. For every one record in CTIL there is one or more records in the TILA table. The primary key field in CTIL is CTIL_REFERENCE the foreign key field in TILA is TILA_REFERENCE.

Basically what I need it to look like is:

One row of data from CTIL must appear, then directly after all the corresponding fields from TILA, then the next CTIL fields and the next corresponding TILA fields and so on...

The above is happening in a sup report.

Thanks for the help, my SQLs gone all rusty.

Thanks so much for your help. Will try this first thing when I go back to work.