Wrapping large data on mailing labels

Hi,

I have used Crystal Reports (VS.net 2005) to create some mailing labels. These work fine providing there is one record per label and the data fits onto the label ok.

However we now have a requirement for labels such as this:

Name
Product 1
Product 2
Product 3
Product 4
Product 5
etc

The number of products listed will be variable and could well be larger than one label. What we want to happen is that the Name field is printed on the first available label and the products flow down the page, using as many labels as possible. We are use 3x7 sheets of labels so when it gets to the bottom of the page it needs to use the next column etc.

I have tried grouping the data by Name, and constructing a large string with the products seperated by a line break. The line break approach works ok but Crystal Reports only uses one label per record and does not flow down to the next label. I cannot see any obvious options to enable this.

Thanks in advance for any help it would be much appreciated!

Kev