>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
Why not have an object for each one of these and use the Print When setting for each one? The report may be ugly in design time, but it should work well.
One plus, at least, is that if a loan type changes, just that object needs to be changed/removed/added, and she won't have to hunt through a long IIF() statement to change/remove/add it.
HTH
Insanity: Doing the same thing over and over and expecting different results.