APEX 5 interactive report column order

Question

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?

Answer 1

So what we can do here is, once you run your report and see the output.

Click on "Action" button on your report output, near the Search bar. Then choose "columns". Now in the next pop up window, you can reorder the columns and even opt to not show some of the column. Once you are done with the changes, click on "Apply".

Now you need to follow these steps to make these changes default for all. Actions --> Reports --> Save Report --> Choose "As Default Report Settings" in save drop down menu --> Apply.

Now your changes will be done and saved as default for all.

Answer 2

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