Solved: Misalignment Between Oracle APEX Interactive Report Headers and Column Values

Nice post, I would suggest the template directive option first because it keeps the SQL query cleaner. It can even be simplified

 #JOB#{case JOB/}{when CLERK/} (STAFF){endcase/}