Formula not displaying variable on rpt 1

[RenaG]

Hi,

Using Crystal 10.

I have this formula in my report:

stringVar MedOncDoc := "N/A";

If {Config_1.Inst_Abrv} like "*MED" then
   MedOncDoc := {Staff.Initials}
else
If {Config_2.Inst_Abrv} like "*MED" then
   MedOncDoc := {Staff_1.Initials}
else
If {Config_3.Inst_Abrv} like "*MED" then
   MedOncDoc := {Staff_2.Initials};

MedOncDoc

Why does it not display "N/A" if none of the conditions are true?

~RLG

 

[briangriffin]

This should work for you. Sometimes you need the catchall at the end, sometimes you don't, but I think it's a good practice to always include it.

stringVar MedOncDoc := "N/A";
If {Config_1.Inst_Abrv} like "*MED" 
then   MedOncDoc := {Staff.Initials}
else
If {Config_2.Inst_Abrv} like "*MED" 
then   MedOncDoc := {Staff_1.Initials}
else
If {Config_3.Inst_Abrv} like "*MED" then   MedOncDoc := {Staff_2.Initials}
else
MedOncDoc;

 

[RenaG]

I actually tried a variation of your suggestion first. I just put

else
    "N/A";

When that didn't work I tried using a variable.

I modified my code as you suggested and it still does not display the "N/A".

TIA!

~RLG

 

[lbass]

You probably need to check for nulls:

If not isnull({Config_1.Inst_Abrv}) and
{Config_1.Inst_Abrv} like "*MED" then
{Staff.Initials} else
If not isnull({Config_2.Inst_Abrv}) and
{Config_2.Inst_Abrv} like "*MED" then
{Staff_1.Initials} else
If not isnull({Config_3.Inst_Abrv}) and
{Config_3.Inst_Abrv} like "*MED" then
{Staff_2.Initials} else
"N/A"

Another possibility is that the formula is case sensitive and "MED" isn't always in caps. If that is the case, wrap each config_n.Inst_Abrv field in ucase().

-LB

 

[RenaG]

That did it! Thanks so much LB.

One of these days I will remember to check for Nulls ;-)

~Rlg