Modifying Layout in IRis 2.3 in Publication/Directories 

You want to create Publication/Directories, and you like the format for example Windows 8 1/2 *11 alpha by agency with index type 3. You’d like to also add all the phone numbers, Web site, Email, and Fees to the Programs, and Phone Number, Email, and Web Site to the Agencies.

Open IRis, go to Supervisor Menu – Files – Publication/Directories. Create or double-click on directory.  

1.    In “Directory Record” window select your layout, i.e. “WINDOWS: 2 column 8 1/2 x 11, Alpha by Agency, indexes, Type 3”, click on “Use This Layout” button.

2.    Click on “Select Programs” and select programs you want to be included in publication.

3.     Click on “Print or Preview Now” button, and select “Modify Report Layout” check box. Your layout window will open.  

To add a phone number, Email, and Web Site of the agency:  

a) Move “Group Header” 1:number down

b) Drag (agency.add2) and (agency.add2) fields down as shown on the picture:

c) Click on [ab] button, and click on empty area within the red ellipse.

d) In field next to the “Expression” button type “Email: “  (with quotes)

e) Click on “OK” button. This should place the word Email in your layout. You can drag it to the proper position. See picture:  

f) Click again on [ab] button, and click on an empty area within the red ellipse as you did in step c)

g) Click on “Expression” button to open “Expression Builder”

h) In drop down “From Table: “ select Agency

i) In “Fields: “ find and double-click on e_mail. “Agency.e_mail” should appear in “Expression for Field  on Report: “ See the picture:  

g) Click on “Ok” buttons, and move the newly created field to the proper position (see next picture)        

f) Repeat the steps c) – g), except in stead of “Email: “ type in “Web Site:” (step d)), and  “e_mail” type double-click on “url” (in step i)). You should also resize inserted fields. You can see how it suppose to look in the next picture:  

To add a phone numbers, Email, and Web Site of the programs:  

a) Move “Detail” down, and drag IIF(Empty(ALL(Programs.dir_notes) and IFF(LEFT(programs.season_st,2) fields down to make a space:

b) Click on IIF(EMPTY) and press CTRL + C on your keyboard.

c) Press CTRL + V. This will Copy and Paste IIF(EMPTY)

d) Double-click on newly created IIF(EMPTY), and click on “Expression” button

e) You should be able to see: IFF(EMPTY(Programs.e_mail),””, “E-mail:”).

f) Change it to IFF(EMPTY(Programs.tele1),””, “Phone1:”)

g) Click on “Ok”

h) Click on ALLTRIM(Programs.e_mail) field, do CTRL + C, and than CTRL + V.

i) This will create new ALLTRIM(Programs.e_mail)

j) Change it to : ALLTRIM(Programs.tele1) the same way like you changed it in step d) and e). 

k) If you need a list of all the phones listed in the programs, you can do the same procedure as in steps b) through f), and than steps h) through j). That means copy and paste both fields, but the only thing you will have to do is change tele1 to tele2 (up to tele5) in both IFF(EMPTY(Programs.tele1),””, “Phone1:”), and  ALLTRIM(Programs.tele1). You also have to change Phone1 to Phone2 (up to Phone5) in field IFF(EMPTY(Programs.tele1),””, “Phone1:”). See the next picture.

l) Exactly the same thing you would do to insert Web Site and Fees of the program:

m) To insert Website: Copy and paste two fields:  IFF(EMPTY(Programs.tele1),””, “Phone1:”), and  ALLTRIM(Programs.tele1). Change tele1 to url, and change “Phone1: “ to “Web Site:”.

n) To insert Fees: Copy and paste two fields:  IFF(EMPTY(Programs.tele1),””, “Phone1:”), and  ALLTRIM(Programs.tele1). Change tele1 to fees, and change “Phone1: “ to “Fees:”. See the picture: