IF statements is one option, but performance-wise, it would take a hit if you're calling that formula for every record, for thousands of records.

So another option that I prefer is to simply build the list of strings that you want to display and refer to it.

1. Create a formula that will hold an array of strings, where each index corresponds to the job type. You will want to use a global variable and separate this from your formula because re-defining the array also wastes time (though it is minor)

global stringvar array names := ["Field", "Workshop" ... ];

0; //Because you can't return an array, so just return something

Place this formula in the report header because it must be available on the report. Suppress it so it doesn't show.

2. Create another formula that will first declare that you're using the global variable, and then return the element located at that index.

global stringvar array names;

names[{job_type_number}]

Where job type number is a number type field from your description (you can convert it to a number if necessary). Now you don't have to use IF's.

Edited by Keikoku - 01 Apr 2011 at 7:07am

Yes, as your indices will rely on that.