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

Null values in crystal reports

Hi everyone

I am doing a report at the min and I am trying to display a persons title, initial and surname as all one field using the formula editor

I noticed some records where left blank  - I have narrowed the cause down to one part of the name being null meaning the records were not being displayed

eg initial could be null or title could be null

Is there anyway I can do it that I can write in the formula if either title, initial or surname are null just output the record with the rest of the output and leaving a space where the field is null

Help greatly appreciated
1 Solution
use a text Object
and inside it place your
I think
This may solve your your Problem
lisa_mcAuthor Commented:
Thanks that worked a treat

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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