---
title: "Comment by Louis Moreaux on \"Solved: Misalignment Between Oracle APEX Interactive Report Headers and Column Values\" | Hashnode"
description: "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/}"
url: "https://hashnode.com/posts/solved-misalignment-between-oracle-apex-interactive-report-headers-and-column-values/673da8671e4fb21c004d7954/comment/673dac4b3d1e6b7e042589c0"
---

[Discussion](https://hashnode.com/posts/solved-misalignment-between-oracle-apex-interactive-report-headers-and-column-values/673da8671e4fb21c004d7954)

Comment [Solved: Misalignment Between Oracle APEX Interactive Report Headers and Column Values](https://hashnode.com/posts/solved-misalignment-between-oracle-apex-interactive-report-headers-and-column-values/673da8671e4fb21c004d7954)

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Nov 20, 2024](https://hashnode.com/posts/solved-misalignment-between-oracle-apex-interactive-report-headers-and-column-values/673da8671e4fb21c004d7954/comment/673dac4b3d1e6b7e042589c0)

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/}
```
