Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Genius begins great works; labour alone finishes them
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Display Form Letter Addresses without Spaces in Crystal Reports?

Over the last couple of months, we have had a number of clients asking "How Do I remove the spaces when creating addresses in form letters?"

There are a number of ways of curcumventing the missing data within the fields that make up the clients' addresses.

The quickest method is to use the functionality of the report sections of Crystal Reports.


  1. Create a group, using the Customer ID.

  2. Split the resultant Group Header section, into as many sections as the datasource has address fields

  3. Add the one address field to each Group Header section

  4. In the Section Expert, select the first split Group Header section

  5. Select the Suppress Blank Section option

  6. Repeat for all the Group Header sections

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

81 + 21 =