Link to home
Start Free TrialLog in
Avatar of lisa_mc
lisa_mcFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of code_me
code_me

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lisa_mc

ASKER

Thanks that worked a treat