I want to display the list of invoices group by Supplier name.

Assume In my recordset i am having 10 suppiler name as supplier1,supplier2,.....Supplier10.I would like to display only one supplier per page,so here My expectation is 10(approx) pages.And maximum number invoices per page is only 10 records, if a suppiler having more then 15 invoices then i need 2 pages for this supplier.

any direction to resolve this issue?...Please...!

Thanks for your valuable help.

Here the format

 

Page 1

--------

Supplier1

Lsit of ivoices for this supplier

 

 

Thanks for your help

It's working fine now.