Hi All,

Is it possible to use a case statement in the expression of a field in a report form?

This works in a third party report writer (R&R):

case(section,"A","Mares Foaled","B","Mares Bred","C","Mares Treated","D","Absentees","")

If I enter this in the expression box in a field added to the vfp report designer and, then run the report, I get a "case.prg not found" error message.

I guess I could use iif's in multiple fields but it seems easier to use the case.

Any help would be appreciated.

Thanks,

Jim Harvey
jharvey@netrax.net