Hello all, hopefully someone can help me out here. I've got a column in my report that has data coming from two fields within the database and I'm not sure how to show this in my table.
To clarify, the column to be populated in my report is called "Length of Occupancy". In my database table, the value for this column can come from two fields: OVER_90_DAYS or LESS_90_DAYS. They are populated with y or n. The one that is set to 'y' needs to be displayed in the table.
How do I get the Length of Occupancy column to show the text "Over 90 days" or "Less than 90 days"? I hope this makes sense to someone. Thanks.
IP Logged
