Hi,

I am writing a labels report to print address labels from an Access database. I have concatenated Town and Zip fields in to a new formula field "TownZip" and also the title and full_name field into "FormalName"

I am finding that where one of the concatenated fields is empty, the new formula field is suppressed. Changing   "supress if blank" option has no effect. If, for example I add "Mr" to title field on a database record, then all is well. But whenever any of the concatenated fields are empty, then nothing is printed for that line. I am using Version 11, yet I had successfully done this before with v8.5.

Anyone can help how to solve this?

Many thanks,

Talat

I'm not sure that the feature that kostya mentions is available in Crystal 8.5. If it's not, you'll have to do something like the following:

StringVar title := "";
StringVar full_name := "";
if not IsNull({MyTable.Title}) then title := {MyTable.Title} + " ";
if not IsNull({MyTable.Full_Name}) then full_name := {MyTable.Full_Name};
title + full_name

You would do the same type of thing for your Town/Zip combination.

For more information about working with null values in Crystal, see my blog post here: http://sapbiblog.com/2013/03/25/what-is-null-and-why-is-it-important-for-crystal-reports/.

-Dell