Grouping two data bands in the same group
Posted: Wed Jun 17, 2009 5:03 pm
I have a table that contains address information for customers. I want to create a report grouped by last name. I want to list all the customers' addresses. Customers can have many addresses and this can (and does) flow over to additional pages. I separately want to list all the customers Street Names. When I print this, I want to print like this:
Customer Header (name, etc.)
Address 1
Address 2
Address 3
Address 4
Address 5
------ Page Break -----
Street Name 1
Street Name 2
Street Name 3
Street Name 4
I tried using the Collate property but each customer spans a different amount of pages.
How can I do this?
Customer Header (name, etc.)
Address 1
Address 2
Address 3
Address 4
Address 5
------ Page Break -----
Street Name 1
Street Name 2
Street Name 3
Street Name 4
I tried using the Collate property but each customer spans a different amount of pages.
How can I do this?