>The solution has to be something just within Report Designer or an external app, meaning i could write a little app just for her lookup.

Nah, put a PRG in the path somewhere called getloantype.prg, make it look like this:

lparameters tnType
do case
	case type('tntype') <> 'N'
		return ""
	case tnType = 1
		return "Type1"
	case tnType = 2
		return "Type2"
	...
endcase

Then, in the report field, just put:

getloantype(loan_type)

And you shoudl be good to go.