The formula doesn't return data

[WaelYassin]

Dear All,
i am using CR9 on DB oracle 8i,
i am trying to build a paragraph using a formula, here is the code which i put on the formula:

WhilePrintingRecords;
stringVar strText :="";
strText :="A fax of readiness should be sent to our freight forwarder """ + {MMS_COMPANY.COMPANY_NAME} + " FREIGHT SERVICES"" at the following address:";
strText := strText+ chr(13);
strText := strText + {MMS_COMPANY.COMPANY_COMMENT};

if {MMS_PO.PO_SUPPLIER} = 'PFS-EUR' then
strText := strText+ " BR5 3HP, UK";

strText := strText+ " , Tel.:" + {MMS_COMPANY.COMPANY_TEL}+","+ chr(13);
strText := strText+ "Fax:" + {MMS_COMPANY.COMPANY_FAX}+", Att.:" + {MMS_COMPANY.COMPANY_CONTACTPERSON} + chr(13);
strText := strText+ "This fax of readiness should state the following details and a copy should be sent to ""QARUN Pet. Co."" for the attention of Materials Gen. Mgr. at least one week prior to delivery date stating:";
strText := strText+ chr(13);
strText := strText+ chr(9)+ "1- The exact delivery date." + chr(13);
strText := strText+ chr(9)+ "2- The exact place of delivery." + chr(13);
strText := strText+ chr(9)+ "3- The name of contact person.";
strText

and i put the formula on group section. but it shows nothing????
any suggestions?
Thanks.

 

[Madawc]

First, why are you using a formual? You could do the same in a Formula Field.

But if you must, I'd advise doing test formula fields to do part of the task, see what's going wrong.

Nulls are a common reason for finding nothing. Try tested for them using IsNull.

Also which part of the group are you using? Header or footer? Is the data you are using there at the time? Should you maybe use on formula field to collect from detail lines and another to show in the group footer?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

I think you have overly complicated the formula, but first, did you format it to "can grow"?

-LB