>My client has a report and wants to translate a user defined code into a description on the report. Currently she has a IIF(loan_type == '1', 'Construction', IIF(loan_type == '2', 'Line of Credit', IIF(loan_type == '3' .... etc. She now has so many loan_types that the Express Builder's Express of Field on Report, scrolling text box is at the maximum. How else can she accomplish her code translation?
>
Brenda,

Use a lookup table for the codes that has two fields, code and description. The records in the lookup table would be;

1       Line of credit
2       Construction
...

Prepare for the report by using a SELECT statement to get the data;

SELECT MainTable/*, CodeTable.Description AS CodeDesc;
  FROM MainTable JOIN CodeTable ON MainTable.Code = CodeTable.Code ;
INTO CURSOR MyReport

Now drive the report from the cursor created and print CodeDesc where you want the description to appear.