<div>
I don't see anywhere that the problem exists.<br />
<br />
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?<br />
<br />
One thing you could try would be to create a new formula <br />
ProductCategoryPage<br />

<pre><code class="code-1 nolinks" id="code-20-42078577-1"><span>If Left({ProductCategoryField},1) = 'M' then</span>
<span>    'M'</span>
<span>Else</span>
<span>   {ProductCategoryField}</span>
</code></pre>
<br />
Add a group based on that formula (insert it then move it so it is before group 6)<br />
DO the page break on that group.<br />
<br />
mlmcc
</div>


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


<div>
I have it working but because you have so many group headers suppressed it is difficult to verify<br />
<br />
mllmcc<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/04_w14/1154728/ProductOutstandingOrdersDinSan--1-.rpt" target="_blank" class="file-inline" title="revised report (232 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ProductOutstandingOrdersDinSan--1-.rpt</a>
</div>


ProductOutstandingOrdersDinSan--1-.rpt

<div>
Ok I'll try it out ...<br />
<br />
The other point I need to mention is that the leading characters need to include<br />
<br />
A, C, D, M, O<br />
<br />
So the formula needs to factor these in
</div>


<div>
I have tried your modified report, it's not working correctly.<br />
<br />
I will explain again.<br />
<br />
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.<br />
When they change (change from M to O) a page break is forced.<br />
<br />
The formula needs to factor in:<br />
A, C, D, M, O
</div>


<div>
I have got the formula working now, (PageBreakCategory) however it's not grouping the 'M' (first digit) together.<br />
Please find attached sample report with saved data.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/04_w14/1154771/ProductOutstandingOrdersDinSan.rpt" target="_blank" class="file-inline" title="ProductOutstandingOrdersDinSan.rpt (232 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ProductOutstandingOrdersDinSan.rpt</a>
</div>


ProductOutstandingOrdersDinSan.rpt

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have the attached crystal report forcing a page break on change of 'Product Category'.<br />
The issue with is that the product categories are like:<br />
<br />
M001<br />
M002<br />
M003<br />
<br />
I need all the &quot;M&quot; to be on one page and then when the product category changes, to then force a page break, EG if the product category went to ORD.<br />
<br />
Please find attached a save with data copy of the file.<br />
<br />
Thanks.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/04_w14/1154560/ProductOutstandingOrdersDinSan.rpt" target="_blank" class="file-inline" title="ProductOutstandingOrdersDinSan.rpt (231 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ProductOutstandingOrdersDinSan.rpt</a>
</div>
</div>


Hello,

I have the attached crystal report forcing a page break on change of 'Product Category'.
The issue with is that the product categories are like:

M001
M002
M003

I need all the "M" to be on one page and then when the product category changes, to then force a page break, EG if the product category went to ORD.

Please find attached a save with data copy of the file.

Thanks.

Page Break in Crystal Reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.