So far I've done simple reports using crystal reports with a repeating section and all. Now I need to make a report that has two repeating sections with data taken from two tables, they are related of course-1 to many.

First table is Invoice table and second table is InvoiceItems. The Invoice table has the general information of an invoice, and the InvoiceItems table lists the Items associated with a particular invoice.

In the report, I want to be able to list all the Invoice as well as all the items of each Invoice.

I guess to get the data I use an SQL statement, but how do I design the report in the report designer?

I use Visual Basic 2005

Please help.

Thanks