• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 857
  • Last Modified:

How to concatenate address fields in Crystal Reports

I have city, state, and zip code fields that are spaced too far apart on a report. I want to create a formula to keep them together and then select Can Grow option for the formula field. When I set my formula as this:
there is an error "A boolean is required here." What is the correct syntax for this?
  • 2
1 Solution
use + and add an empty space between the fields

{InvoiceGen.Custcity} + ' ' + {InvoiceGen.Custstate} + ' ' + {InvoiceGen.Custzip}
MashaCPAAuthor Commented:
Perfect, thank you! I tried a similar formula as well but with "" instead of '', and there was a different error. Thanks for your help!
You are Welcome!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now