Grouping with only one record (1 Viewer)

[TimTDP]

I have a report showing products and their selling prices
Most products have only one selling price, however a few have more than one selling price
To cater for this I have created a group called "Products"
The selling prices are then in the reports' "details" section.

Works well, except that every product now spans 2 lines. One for the product description and another for the price. This doubles the number of pages in the report.

As products with only one price is the norm, is there a method that I can adopt to show products:
* with one selling price - product description and selling price on one line
* with more than one selling price - product description and first selling price on one line, with subsequent selling prices on line below?

Thanks in advance

 

[JHB]

I would use a subreport for the more than one selling price, reduce the hight of the sub report to the minimum.