Oftentimes it is necessary to set up a report that will do a SELECT on the same field multiple times.  You might have a report that prints for a set list of financial classes, insurances, locations or physicians.

Here are two methods for taking care of this...

METHOD 1: entering multiple SELECTs on screen 2.

With this method, you enter your list into the SELECT fields and utilizing the SELECT RELATIONSHIP to 'OR' the SELECTs.  A picture of how this would look appears below:

Using this method works fine, but has a few downsides:

things can get 'out of hand' if you have too many values in your list of SELECT criteria.

adding more values to your SELECT criteria means updating your SELECT RELATIONSHIP.

adding different SELECT criteria may mean updating your SELECT RELATIONSHIP.

METHOD 2: pre-loading your SELECTs into and ARRAY.

This method involves a number of steps, but has none of the downsides associated with Method 1.

STEP 1: set up a 'start' macro.

This code will pre-load the values you wish into the array /FIN.CLASS.  You can name the array whatever you want.  You can make this array as large as you want.

STEP 2: reference your /FIN.CLASS array on Page 2.

STEP 3: add the 'start' macro reference in the EDIT FOOTNOTES section on Page 3.