[RESOLVED] formula field

i have a formula field. Here is the code:

Code:

---

stringVar array x1 := "";
stringVar result := "";
numberVar i;
numberVar top := ubound(split({tblJobs.scflist},'|'));
for i := 1 to top do
(
  redim preserve x1[i];
  x1[i] := split({tblJobs.scflist},'|')[i];
 
  result := result + x1[i];

  result := result + chr(10);
);

if {tblJobs.choosescf} and result = "" then "Please Advise" else result;

---

if {tblJobs.scflist} is null then i get no result. it will not process anything after the for loop. how can i get around this?

When a Null field is encountered in a formula Crystal immediately stops evaluating the formula and no result is returned.

Add an If statement and check if the field is null or not.

Code:

---

stringVar array x1 := "";
stringVar result := "";
numberVar i;
numberVar top := 0;

If Not IsNull({tblJobs.scflist}) Then
(
  top := ubound(split({tblJobs.scflist},'|'));
  for i := 1 to top do
  (
    redim preserve x1[i];
    x1[i] := split({tblJobs.scflist},'|')[i];
 
    result := result + x1[i];

    result := result + chr(10);
  );
)

if {tblJobs.choosescf} and result = "" then "Please Advise" else result;

---

ok. thanks for the info.
when i tried the code but i get an error:

The remaining text does not appear to be part of the formula.

and it is on the very last line.

this works.

Code:

---

stringVar array x1 := "";
stringVar result := "";
numberVar i;
numberVar top := 0;

If Not IsNull({tblJobs.scflist}) Then
(
top := ubound(split({tblJobs.scflist},'|'));
for i := 1 to top do
(
  redim preserve x1[i];
  x1[i] := split({tblJobs.scflist},'|')[i];
 
  result := result + x1[i];

  result := result + chr(10);
);
if {tblJobs.choosescf} then "Please Advise" + result else result;
)
else if {tblJobs.choosescf} then "Please Advise"

---

I think I missed the semi-colon after the after the end bracket of the first If statement.

Code:

---

    result := result + chr(10);
  );
);

if {tblJobs.choosescf} and result = "" then "Please Advise" else result;

---