Solved

Joining Several Fields into One

Posted on 2011-09-14
2
191 Views
Last Modified: 2012-05-12
Good afternoon,

I have address fields that I want joined into one field to place in a report.
Sounds like an easy request but I have tried and no data is present when you run the report.

I have tried addressline1 & " "& addressline2

As well as addressline1 + addressline2

No data is returned in the report...

Any help would be appreciated,

Thank you-
cms
0
Comment
Question by:rporter45
2 Comments
 
LVL 22

Accepted Solution

by:
Ido Millet earned 125 total points
Comment Utility
If one element is null, the whole expression returns null.

IF IsNull(addressline2)
Then  addressline1 & " "& addressline2
ELSE addressline1


0
 

Author Closing Comment

by:rporter45
Comment Utility
If Statement is slightly off,

It should be then addressline1 else addressline 1 & " "& addressline2

Thank you!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now