put subreport after report

[tizwaz]

I have a report which list who is responsible for certain tasks (there can be several names for each task). I want to insert a subreport which lists who is the back up person responsible for tasks.
I have 3 tables - tasks (task id, task desc)
StaffResponsible (staffid,taskid)
BAckup (staffid, task id)
If I try and pull all the info into one query I can't put the names for both the person responsible and the back up person in the same query so I am trying 2 queries with a report based on one and a subreport based on the other. However the report lists the 1st task with the 1st person responsible followed by the subreport with the 1st back up person, then the 2nd person responsible followed by the subreport with the 1st back up person repeated.

I need the report to list for each task who is responsible followed by who the back up person or people are. How can I do this?

 

[lupins46]

You need to group the report on taskid and put the subreport in the group footer.

 

[tizwaz]

thank you - that works great