1. Create a formula to extract the first letter of the last name
    1. Open the report in design view
    2. Open the Field Explorer (click View, Field Explorer) and select Formula Fields
    3. Click on the New icon on the upper toolbar and enter a formula name. Ex: FirstLetterLastName
    4. Enter a formula to print the first letter of the last name. Ex: Left({CnBio.CnBio_Last_Name},1)
    5. Click Save and Close
       
  2. Create a Group based on that formula field
    1. Click on Insert, Group
    2. Select the formula field name that was created in step #1. Ex. FirstLetterLastName
    3. Click OK
       
  3. Suppress the Group footer by right-clicking on the Group Footer section and selecting Suppress