Search code examples
oracle-apexoracle-apex-5

APEX 5 interactive report column order

I have an issue with changing interactive report column order. My APEX version 5.0.3.00.03.

If i change order in Columns nothing change. If i change order in SqlQuery nothing change. If i change type of report (eg select classic report) and come back to interactive order finally change.

I'm doing wrong or there is a bug?

Solution

  • SQL statement order is merely defines the default order upon creation, and has no impact afterwards.

    Classic reports get their order from the column sequence at design time.

    Column order for interactive reports is defined at runtime, where the developer uses action toolbar to select columns, order, sort etc.

    Design time capability for IR may be present in APEX 5.2