I am trying to create an app that creates invoices from data in a database.  
Sales information is imported/entered throughout the day, then at EOD, all
the reports are generated and printed.

The data in the order information database might look something like:

OrderNumber / CustomerName / Item / Price
0001 / John / Ord1Itm1 / 1.00
0001 / John / Ord1Itm2 / 1.54
0002 / Sally / Ord2Itm1 / 2.00
0003 / Steve / Ord3Itm1 / 1.00
0003 / Steve / Ord3Itm2 / 4.30
0003 / Steve / Ord3Itm3 / 3.50

As you can see, a single order may have several records to reflect line item
information.

What I would like, is when the "report" is run, each page contains a single
invoice, so in this example, there would be 3 pages.  Page 1 would have John
and itemize his 2 items, page 2 would have Sally and her Item, etc...

I am able to get the report to come out correctly if i specify the order
number:
I.e., Use:  "Select * from Orders where OrderNumber = '0001'"

So this means the report would need to be run 3 times in this example.  I
would like to use instead:  "Select * from Orders", that way i only have to
run the process once.

Any suggestions or information is much appreciated.