Null values in crystal reports

Posted on 2011-05-06
Last Modified: 2012-05-11
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
Question by:lisa_mc
    LVL 1

    Accepted Solution

    use a text Object
    and inside it place your
    I think
    This may solve your your Problem
    LVL 3

    Author Closing Comment

    Thanks that worked a treat

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    728 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

    23 Experts available now in Live!

    Get 1:1 Help Now