title: Crystal Reports combine fields in string formula, one field no data
body: <p>I was given a formula:</p>
  
  <pre><code>if not (isnull({PERSON.LAST_NAME})) then 
  {PERSON.LAST_NAME}+","+" "+{PERSON.FIRST_NAME}
  else 
  "No Name"
  </code></pre>
  
  <p>This formula seems to work fine but I need to add the field {PERSON.MIDDLE_NAME} however when I write the formula</p>
  
  <pre><code>if not (isnull({PERSON.LAST_NAME})) then 
  {PERSON.LAST_NAME}+","+" "+{PERSON.FIRST_NAME}+","+" "+{PERSON.MIDDLE_NAME}
  else 
  "No Name"
  </code></pre>
  
  <p>if the person has a middle name, it looks fine. If the person does not have a middle name and there is no data in the field, then the report shows no information at all. </p>
  
  <p>Apologies for what is likely a very beginner question, and thank you in advance.</p>