• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 889
  • 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:
{InvoiceGen.Custcity}And{InvoiceGen.Custstate}And{InvoiceGen.Custzip}
there is an error "A boolean is required here." What is the correct syntax for this?
0
MashaCPA
Asked:
MashaCPA
  • 2
1 Solution
 
vastoCommented:
use + and add an empty space between the fields

{InvoiceGen.Custcity} + ' ' + {InvoiceGen.Custstate} + ' ' + {InvoiceGen.Custzip}
0
 
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!
0
 
vastoCommented:
You are Welcome!
0
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

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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