I have a data set that contains multiple records where name field is same, however there are invoice numbers that are different, so Name1 may have 3 records, but 3 different invoice numbers. Then Name2 has 2 Invoice numbers on so on.
Name1 Invoice100
Name1 Invoice130
Name1 Invoice141
Name2 Invoice110
Name2 Invoice135
Name3 Invoice110
Name3 Invoice410
Name3 Invoice480
So the report output would be:
Name1
Invoice100
Invoice130
Invoice141
----------Page Break
Name2
Invoice110
Invoice135
----------Page Break
Name3
Invoice110
Invoice410
Invoice480
Etc...
I can't figure out how to force the Page break when it moves to next Name.
Any suggestions.