CODEWITHSUNDEEP
oracle-databaseoracle-apex-5
Marcelo Zanol
Marcelo Zanol

Reputation: 1

What determines default Interactive Report column display in Oracle APEX 5?

I have an Interactive Report page in Oracle APEX 5 that includes a SQL Query with ~15 columns or so. When I first load the report, the columns are in a certain order, and columns are set to Do Not Display (as seen under Actions-> Select Columns).

All the columns have the property Type as Plain Text and none has a condition defined in the Page Designer, under {Page Name} -> Regions -> Content Body -> {Interactive Report} -> Columns.

My Interactive Report has a dynamic query under a APEX_COLLECTION and the end user doesn't have developer privilegies.

My question is, what determines which columns are set to Do Not Display and those set to Display in Report?

Upvotes: 0

Views: 4436

Answers (1)

eaolson
eaolson

Reputation: 15094

When you first create an Interactive Report, all the columns will be present in the Designer under the Columns list and in the order in which they appear in the SELECT statement. When you run the page, the IR will display all the columns.

If you edit the SQL behind that IR to add columns, any new columns will appear at the end of the Columns list. You will have to run the page, select Actions > Select Columns, and add them to the displayed list of columns to have them display. You'll probably want to then select Actions > Save Report as the primary default report to have them displayed by default for your users.

Upvotes: 5

Related Questions