Page Break in Crystal Reports

I don't see anywhere that the problem exists.

Do you want all product categories that start with M grouped so there is no page break or are there some product categories that start with M that should cause a page break?

One thing you could try would be to create a new formula
ProductCategoryPage

If Left({ProductCategoryField},1) = 'M' then
    'M'
Else
   {ProductCategoryField}

Select allOpen in new window

Add a group based on that formula (insert it then move it so it is before group 6)
DO the page break on that group.

mlmcc

All product categories that start with Mr grouped and when the first character changes EG to O then force a page break

That should be M

I can't seem to get it to work ...

I have it working but because you have so many group headers suppressed it is difficult to verify

mllmcc
ProductOutstandingOrdersDinSan--1-.rpt

Ok I'll try it out ...

The other point I need to mention is that the leading characters need to include

A, C, D, M, O

So the formula needs to factor these in

I have tried your modified report, it's not working correctly.

I will explain again.

I need to group the product category field, so all the ones which start with 'M' are grouped. All the ones which start with 'O' are grouped.
When they change (change from M to O) a page break is forced.

The formula needs to factor in:
A, C, D, M, O

I have got the formula working now, (PageBreakCategory) however it's not grouping the 'M' (first digit) together.
Please find attached sample report with saved data.
ProductOutstandingOrdersDinSan.rpt