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?

Ashish Pratap · Answer 1 · 2022-05-20T11:35:59.967

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.

score 2 · Answer 2 · answered Sep 18 '17 at 13:26

2

To change the order of columns displayed go on IR bar "actions" and select "Columns". Here you can choose what display and in which order. Then save the report as default.

answered Sep 18 '17 at 13:26

Roberta T.

21
2

score 1 · Accepted Answer · answered Feb 10 '17 at 03:12

1

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

answered Feb 10 '17 at 03:12

Scott

4,857
3
22
33

5

Update - it's now 18.1, and we're still waiting on IR design time upgrades. – Scott Aug 29 '18 at 01:20
1

19.1 and I still have to come to this question to find out how to design column order. – Rene Aug 23 '19 at 10:40
Still something we do at runtime, as a developer. – Scott Aug 24 '19 at 09:11

score 1 · Answer 4 · answered May 11 '17 at 09:24

1

Don't forget to save the report as default report afterwards or else it will reset on refresh (actions -> save report then choose default from select list).

answered May 11 '17 at 09:24

RLOG

620
6
14

While this might be a good tip, it's not an answer to the question asked - this could perhaps be a comment on the question. – otupman May 11 '17 at 09:53
Actions > Report > Save Report – Sep 08 '21 at 01:51

APEX 5 interactive report column order

4 Answers4