Expanding Source Field in Reports

There are a number of report screens in ZonePro SQL that include a Source field as part of their output (such as the Activity Report Screen). This field is a two character abbreviation of the database that the record is pulled from. Several customers have asked if their is an easy way to make this field more readable on reports by expanding "BD" to "Building Permit", for example. This can be done by using a function that evaluates the field value and outputs the alternative text. Substitute the function below for the expression in any report that prints the "Source" field. You can trim the expression down to include only those databases that matter to you. You can also edit the second argument in each pairing to read the way you want it to.

ICASE(source="ZN","Zoning Permits",source="VL","Violations",source="AP","Appeals",source="AM","Amendments",source="OT","Other Permits",source="EX","Extra Permits",source="PN","Planning",source="BD","Building",source="EL","Electrical,source="PL","Pumbing",source="MC","Mechanical",source="PJ","Project",source="RE","Rental",source="HS","Housing,source="PS","Pre-Sale",source)