>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.