group report with multiple data

ross

hi

I am using FR v4

I have 3 tables and a select statement

SELECT contact_id, name, title, amount
FROM contact, entry, invoices
WHERE contact.contact_id = entry.contact_id
AND contact.contact_id = invoices.contact_id
ORDER BY contact_id

I want the report to show the following

name 1
--entry 1
--entry 2

--amount 1
--amount 2

name 2
--entry 3
--entry 4

--amount 3
--amount 4


I am using Group band on contact_Id and can display the entries, but cannot workout how to display the amounts within the group

please advise

regards

ross