New Page After Question 1

[ecsrs]

I have a group which is sorted by last name. I need to print a new page after each new letter of the alphabet. So I need all the A's on one page, all B's on one page, etc. What formula should I use?

 

[dgillz]

Create a formul field like the following to look at the first letter of the name and place it in the details section:

Left({Fieldname},1}

Then, from the design window, right click the details section, select format, click the "X-2" button to the right of the "new page after" checkbox, and enter the following formula:

Not OnLastRecord;
Next({FormulaField})<>{FormulaField}

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com