C crystal report example mail label

Here is an example of a Crystal Report that generates a mail label:

Mail Label Report

Fields:

• Name: The name of the recipient
• Address: The address of the recipient
• City: The city of the recipient
• State: The state of the recipient
• Zip: The zip code of the recipient
• LabelText: The text to be printed on the label (e.g. "Return Service Requested")

Report Design:

1. Create a new Crystal Report and add the following fields to the report:
   • Name
   • Address
   • City
   • State
   • Zip
   • LabelText
2. Add a Text Object to the report and set its Text property to {LabelText}. This will display the text on the label.
3. Add a Barcode Object to the report and set its Type property to Postnet (or another type of barcode suitable for mail labels). Set the Value property to {Zip}. This will generate a barcode for the zip code.
4. Add a Text Object to the report and set its Text property to {Name}. This will display the name of the recipient.
5. Add a Text Object to the report and set its Text property to {Address}. This will display the address of the recipient.
6. Add a Text Object to the report and set its Text property to {City}, {State} {Zip}. This will display the city, state, and zip code of the recipient.
7. Set the Font property of the Text Objects to a font suitable for printing labels (e.g. Arial, 12pt).
8. Set the Alignment property of the Text Objects to Left or Center depending on your preference.
9. Set the Width and Height properties of the report to the desired size for the mail label.

Formula:

To generate the label text, you can use a formula to concatenate the fields. For example:

{LabelText} + chr(13) + chr(10) + "{Name}" + chr(13) + chr(10) + "{Address}" + chr(13) + chr(10) + "{City}, {State} {Zip}"

This formula will generate the label text with the specified fields and formatting.

Example Output:

Here is an example of what the report might look like:

Return Service Requested
John Doe
123 Main St
Anytown, CA 12345

This is just a basic example, and you can customize the report to fit your specific needs. You can also add additional fields or formatting to make the report more complex.